Re: v$session with same serial#

From: Rafael Alberto Hernandez <ralberto.hernandez.ext_at_juntadeandalucia.es>
Date: Thu, 10 Jan 2013 10:15:10 +0100
Message-ID: <50EE869E.4040401_at_juntadeandalucia.es>

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

Received on Thu Jan 10 2013 - 10:15:10 CET