RE: v$session with same serial#

From: Powell, Mark <mark.powell2_at_hp.com>
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-l
Received on Thu Jan 10 2013 - 18:07:13 CET

Original text of this message