Re: EM12c reporting two sessions with same SID

From: Martin Berger <>
Date: Wed, 22 Aug 2012 17:53:31 +0200
Message-ID: <>


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?


On Wed, Aug 22, 2012 at 3:44 PM, Rich Jesse <> wrote:
> Hey all,
> While I'm trying to debug some messes, I see that EM12c's Top Activity
> historical data shows at least one 30-minute time period from this morning
> where two of the Top Sessions have the same SID. Since I know the app
> generating these two sessions must do so serially -- one will finish and
> disconnect before the other starts -- could this really be the case? Can
> two different direct-connect (no pooling) sessions created within a "short"
> period of time have the same SID?
> Evidence is on, but I know I've also seen this on (which
> is now thankfully gone!).
> TIA!
> Rich
> --

Received on Wed Aug 22 2012 - 10:53:31 CDT

Original text of this message