Oracle Database Discussions

Hello,

My Oracle version is:

Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 

Yesterday I was taking a look on an ADDM report and spot the following:

   Rationale
      SQL statement with SQL_ID "0mgk8gx9hj71d" was executed 777 times and had 
      an average elapsed time of 42 seconds.
   Rationale
      Waiting for event "resmgr:cpu quantum" in wait class "Scheduler" 
      accounted for 34% of the database time spent in processing the SQL 
      statement with SQL_ID "0mgk8gx9hj71d".

After that, I started looking for how ADDM could know that the SQL_ID "0mgk8gx9hj71d" waited 34% on "resmgr:cpu quantum" event. No lucky with that...

The only wait event information related to a given SQL_ID I've found on v$active_session_history (or the AWR persisted table for it), but in the ASH there is no information about CPU wait events like "cpu quantum". When the session is waiting for CPU, there is no event related in v$ash.

So, my question is: where ADDM got the information that the SQL waited 34% of the time on "resmgr:cpu quantum"?

Thanks,

Heitor Kirsten