RE: v$session with same serial#

From: Mark W. Farnham <mwf_at_rsiz.com>
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