RE: v$session with same serial#
Date: Thu, 10 Jan 2013 17:07:13 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD117CCAD59_at_G5W2734.americas.hpqcorp.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rafael Alberto Hernandez
Sent: Thursday, January 10, 2013 4:15 AM
To: Mark W. Farnham
Cc: oracle-l_at_freelists.org
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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Rafael Alberto Hernandez
> Sent: Thursday, January 10, 2013 3:00 AM
> To: oracle-l_at_freelists.org
> 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.
>
> --
> http://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_at_juntadeandalucia.es -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 10 2013 - 18:07:13 CET