Hi Experts,
I am executing a long running query (now since last 55 mins) and want to dig out some details regarding the work performed under the hood.
Got this query from Tim's blog .I am executing this query from another session -
SELECT NVL(a.event, 'ON CPU') AS event,
COUNT(\*) AS total\_wait\_time
FROM v$active_session_history a
WHERE session_id = 722 -- a.sample_time > SYSDATE - 5/(24*60) -- 5 mins
GROUP BY a.event
ORDER BY total_wait_time DESC;
And, on every execution of this query, the "ON CPU" time is increasing keeping all other constant.
Please help me understand what does "ON CPU" means where most of the time is spent. Help much appreciated.
Thanks and Regards,
-- Ranit
( on Oracle 11.2.0.3.0 )