Re: Finding out historical cpu-usage

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-l


Other related posts: