Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql monitoring not capturing all sql

user8363520Feb 6 2012 — edited May 3 2012
Hello all, I am on 11.2.0.1 and using Grid control to monitor activity on my DB. There are quite a few DB session active....one session has over 80K logical reads and about 800+ cpu seconds....and its been goin for about couple of mins...running sql query from command prompt....and it shows up in TOP ACTIVTY in grid control as well...but when i go in SQL Monitoring ...there are no sql query that is active...it says "NO SQL EXECUTION WERE MONITORED SO FAR".... if i click on the drop down list and says show me sql for last 6 hrs or 12 hours it pops up...but if i do last 10 mins...nothing shows up....but as i mentioned session are active on the server for a while...so why is it not being captured by sql monitoring ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2012
Added on Feb 6 2012
8 comments
2,157 views