RE: v$session with same serial#

From: Iggy Fernandez <>
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 FernandezEmail: iggy_fernandez_at_hotmail.comBlog: So Many Manuals So Little TimeAuthor of Beginning Oracle Database 11g AdministrationEditor of the NoCOUG Journal

> From:
> 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#.

Received on Thu Jan 10 2013 - 09:41:26 CET

Original text of this message