v$session with same serial#

  • From: Rafael Alberto Hernandez <ralberto.hernandez.ext@xxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 10 Jan 2013 09:00:18 +0100

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.

--
//www.freelists.org/webpage/oracle-l


Other related posts: