user8363520 wrote:SQL Monitoring is initiated when the SQL first starts.
Hello all, I am on 220.127.116.11 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 ?
I am also facing the simillar issue.
I have started Reports which usually runs for 20 minutes.
When i view the Sql Monitoring page , its showing " No Sql Executions Monitored So far "
The Top Activity page sometimes show these sql's
My db is Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit
Statisticts Level is set to TYPICAL
Is this a OEM configuration issue ? Or we need to set any criteria for Monitoring all the SQL's running in db.
When i ran the report/qruy there was no load in the system.