Finding out historical cpu-usage

  • From: Jan-Hendrik Boll <jan.hendrik.boll@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 11 Oct 2011 11:32:57 +0200

Hi Lister's,
i am currently investigating which session consume the most cpu-time per
In order to do so i am using the view dba_hist_active_sess_history

Tracking down the time spent waiting for typical wait-events like 'log file
sync' seems easy as it is the sum of time_wait for that event.

But how can i find out the CPU-Time?
Is CPU time the sum of wait_time in which the session_state equals 'ON CPU'

Any clarification about the meaning of these two columns would be greatly

Kind regards,
Jan-Hendrik Boll


Other related posts: