Re: EM12c reporting two sessions with same SID
Date: Wed, 22 Aug 2012 10:23:45 -0700 (PDT)
Message-ID: <1345656225.91304.YahooMailNeo_at_web121003.mail.ne1.yahoo.com>
I'm making a few assumptions with my testing here, but I'm thinking it is coming from the samples that are pulled for top sessions. If you look, it should tell you down in the right hand corner, below the top sessions, how many samples were used to create the top sessions view. I was able to duplicate this in my environment. I executed a process that I knew would be identified as a top session, disconnected, then waited a bit, then reconnected and tried again. I did connect with the same sid, executed another high hit process and was able to see my SID show up twice in the list, this time in a different sample from ASH top session data when I drilled down. Hope this helps,
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
RMOUG Director of Training Days 2013
~Tombez sept fois, se relever huit!
From: Martin Berger <martin.a.berger_at_gmail.com> To: rjoralist2_at_society.servebeer.com Cc: oracle-l_at_freelists.org
Sent: Wednesday, August 22, 2012 9:53 AM Subject: Re: EM12c reporting two sessions with same SID
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_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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 22 2012 - 12:23:45 CDT