Re: EM12c reporting two sessions with same SID

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

On Wed, Aug 22, 2012 at 3:44 PM, Rich Jesse <rjoralist2_at_society.servebeer.com> 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 11.2.0.3, but I know I've also seen this on 10.1.0.5 (which
> is now thankfully gone!).
>
> TIA!
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l

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