How to Calculate Oracle CPU usage
If You wants to identify the impact of particular user on the Database,or if you want to determine how much resources are consumed, cpu, IO used by this ID,you can use the following script to display CPU utilization for any Oracle user. select aa.username, bb.SID, VALUE/100 cpu_usage_seconds from v$session a, v$sesstat b, v$statname c where [...]
Written by admin on April 13th, 2012 with comments disabled.
Read more articles on Oracle Tips and Tricks.