Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Feb 19, 2013 5:31 PM by ray_h
Duplicate SQL IDs showing in Top Activity monitor
Feb 19, 2013 5:31 PM
I'm using EM 11g, running against 184.108.40.206.0.
We've recently had a major database release. All seems to be well, apart from some strange behaviour in EM.
In the Top Activity monitor, a new piece of SQL has its SQL ID appearing 3 times. Strangely, they are showing varying resource usage, which suggests different SQL statements.
But then drilling down into each one, I can see the same stats (same SQL, sessions, plan, cost, execution times etc.) for all three.
Unless some collision has taken place, where cursors are somehow sharing the same SQL ID (and this really doesn't appear to be the case), then I'm stumped as to why this would happen.
Has anyone else experienced this type of thing before? Any thoughts/suggestions much appreciated.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies