Re: EM12c reporting two sessions with same SID
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Wed, 22 Aug 2012 17:53:31 +0200
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
On Wed, Aug 22, 2012 at 3:44 PM, Rich Jesse
<rjoralist2@xxxxxxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
