Finding out historical cpu-usage
From: Jan-Hendrik Boll <jan.hendrik.boll_at_googlemail.com>
Date: Tue, 11 Oct 2011 11:32:57 +0200
Message-ID: <CAMqF_e2+K_Vn6q5aWbnRWnmOfDgiP0ReaazvS50DGTeLVJtOqA_at_mail.gmail.com>
Hi Lister's,
i am currently investigating which session consume the most cpu-time per instance.
In order to do so i am using the view dba_hist_active_sess_history
Date: Tue, 11 Oct 2011 11:32:57 +0200
Message-ID: <CAMqF_e2+K_Vn6q5aWbnRWnmOfDgiP0ReaazvS50DGTeLVJtOqA_at_mail.gmail.com>
Hi Lister's,
i am currently investigating which session consume the most cpu-time per instance.
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 appreciated.
Kind regards,
Jan-Hendrik Boll
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 11 2011 - 04:32:57 CDT