Re: EM12c reporting two sessions with same SID

From: <breitliw_at_centrexcc.com>
Date: Wed, 22 Aug 2012 12:49:56 -0600
Message-ID: <20120822124956.25l000twasok4oss_at_webmail.telushosting.com>

SID is not guaranteed to be unique. Only the combination sid-serial# is.

On Wed, 22 Aug 2012 17:53:31 +0200, Martin Berger <martin.a.berger_at_gmail.com> wrote:
Rich,
>
> I'd see it quite unlikely you can get the same SID twice on the same
> instance at any time.
> the column "SID" in v$session is mapped to X$KSUSE.indx - I don't
> expect Oracle developers to call an internal column 'index' if it's
> not unique.
>
> not the best prove, maybe someone else can do better?
>
> Martin
>

  --
Wolfgang Breitling
Centrex Consulting Corporation

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

Received on Wed Aug 22 2012 - 13:49:56 CDT