Re: Finding out historical cpu-usage
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 session_id.