EM12c reporting two sessions with same SID

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 22 Aug 2012 08:44:03 -0500 (CDT)
Message-ID: <87c3464fae4e139a295ea4e0d53962ca.squirrel_at_society.servebeer.com>

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

Received on Wed Aug 22 2012 - 08:44:03 CDT

This message: [ Message body ]
Next message: Nathan Owen: "Seeking Beta Participants for em12c-based plugin for Vmware"
Previous message: Chris Taylor: "RAC newbie plus PARTITIONING newbie - looking for suggestions on the attached SQL"
Next in thread: Martin Berger: "Re: EM12c reporting two sessions with same SID"
Reply: Martin Berger: "Re: EM12c reporting two sessions with same SID"
Reply: Alex Fatkulin: "Re: EM12c reporting two sessions with same SID"
Maybe reply: breitliw_at_centrexcc.com: "Re: EM12c reporting two sessions with same SID"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message