RE: v$session with same serial#
Date: Thu, 10 Jan 2013 03:46:11 -0500
Message-ID: <005e01cdef0e$f1b453c0$d51cfb40$_at_rsiz.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 10 2013 - 09:46:11 CET