RE: v$session with same serial#
From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Thu, 10 Jan 2013 00:41:26 -0800
Message-ID: <BLU165-W42C38F9C36B0885CAC0FB9EB2A0_at_phx.gbl>
That's the expected behavior Ralberto. The SID values are reused during the life of the instance but SERIAL# is extended each time. Therefore it is perfectly natural to see sessions with the same value of SERIAL#. It's the (SID, SERIAL#) combination that you expect to be unique during the life of the instance. Kindest regards,
Iggy
-- Iggy FernandezEmail: iggy_fernandez_at_hotmail.comBlog: So Many Manuals So Little TimeAuthor of Beginning Oracle Database 11g AdministrationEditor of the NoCOUG Journal
Date: Thu, 10 Jan 2013 00:41:26 -0800
Message-ID: <BLU165-W42C38F9C36B0885CAC0FB9EB2A0_at_phx.gbl>
That's the expected behavior Ralberto. The SID values are reused during the life of the instance but SERIAL# is extended each time. Therefore it is perfectly natural to see sessions with the same value of SERIAL#. It's the (SID, SERIAL#) combination that you expect to be unique during the life of the instance. Kindest regards,
Iggy
-- Iggy FernandezEmail: iggy_fernandez_at_hotmail.comBlog: So Many Manuals So Little TimeAuthor of Beginning Oracle Database 11g AdministrationEditor of the NoCOUG Journal
> From: ralberto.hernandez.ext_at_juntadeandalucia.es
> 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#.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 10 2013 - 09:41:26 CET