Re: Finding out historical cpu-usage

  • From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
  • To: free <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Oct 2011 08:18:32 -0700 (PDT)

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 


Other related posts: