Re: Finding out historical cpu-usage
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Wed, 12 Oct 2011 08:18:32 -0700 (PDT)
Message-ID: <1318432712.69798.YahooMailNeo_at_web65912.mail.ac4.yahoo.com>
Did you mean historical cpu usage by username? Take a look at DBA_HIST_SQLSTAT, it has cpu_time_delta for most sql's executed by awr snapshot intervals. You can join this view with DBA_HIST_SNAPSHOT.
Date: Wed, 12 Oct 2011 08:18:32 -0700 (PDT)
Message-ID: <1318432712.69798.YahooMailNeo_at_web65912.mail.ac4.yahoo.com>
Did you mean historical cpu usage by username? Take a look at DBA_HIST_SQLSTAT, it has cpu_time_delta for most sql's executed by awr snapshot intervals. You can join this view with DBA_HIST_SNAPSHOT.
Along with parsing_schema_id (for grouping by user), you can also use columns like module or action.
Just in case if you really need this data by session id, then join DBA_HIST_ACTIVE_SESS_HISTORY with DBA_HIST_SQLSTAT by sql_id to group it by session_id.
Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 12 2011 - 10:18:32 CDT