RE: v$session with same serial#

  • From: "Powell, Mark" <mark.powell2@xxxxxx>
  • To: "ralberto.hernandez.ext@xxxxxxxxxxxxxxxxxxx" <ralberto.hernandez.ext@xxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Jan 2013 17:07:13 +0000

What is strange about it?  The documentation for v$session does not list 
serial# as being unique so why wouldn't you expect duplicate values?

select count(*),serial# from v$session group by serial#;
> l
  1  select count(*),serial# from v$session group by serial#
  2* having count(*) > 1
> /

  COUNT(*)    SERIAL#
---------- ----------
        20          1
         2          6
         2          9
         2      50026

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rafael Alberto Hernandez
Sent: Thursday, January 10, 2013 4:15 AM
To: Mark W. Farnham
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: v$session with same serial#

but it's really strange have at the same time 14 sessions with the same serial# 
this behaviour is not normal in other instances and always occurs in this.

El 10/01/2013 9:46, Mark W. Farnham escribió:
> sid,serial# should be unique as a pair, serial# alone is essentially 
> meaningless.
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Rafael Alberto Hernandez
> Sent: Thursday, January 10, 2013 3:00 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: v$session with same serial#
>
> Hi,
>
> I have a question for your all, i don´t understand because in 
> v$session we have many sessions (BMC/REMEDY) with different sid and same 
> serial#.
>
> I tried to find something about this behavior but i don't find 
> anything reliable in forums,blogs and Oracle Support.
>
> Why does this behavior exists?
>
>
>          SID    SERIAL# MACHINE
> ---------- ---------- --------------------
>         64          1 zzz-server
>         65          6 zzz-server
>         66          3 zzz-server
>         67          3 zzz-server
>         68          3 zzz-server
>         69          3 zzz-server
>         70          3 zzz-server
>         71          3 zzz-server
>         72          3 zzz-server
>         73          3 zzz-server
>         74          3 zzz-server
>         75          3 zzz-server
>         76          3 zzz-server
>         77          3 zzz-server
>         78          3 zzz-server
>         79          3 zzz-server
>         80          4 zzz-server
>         82         50 zzz-server
>         83         58 zzz-server
>         98         50 zzz-server
>
> Thanks & Regards,
>
> Ralberto.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>


--
Rafael Alberto Hernández Ramos

Técnica de Sistemas
Area de Producción de Sistemas
Dpto. Operaciones
Avda. de la Arboleda, S/N.
41940 - Tomares (Sevilla)
Tlf: 671599596 (699596) / Fax: 955 061 019/041

e-mail: ralberto.hernandez.ext@xxxxxxxxxxxxxxxxxxx

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: