Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CPU TIME Analysis

Sarat_yahooDec 20 2014 — edited Dec 22 2014

AWR report we have
DB CPU = 5966s
NUM OF CPUS =32
ELAPSED TIME = 60 mins

So Total CPU for 60 Mins elapsed time is 32x60x60=115200s

So % CPU taken by oracle in 60 Mins =DB CPU / TOTAL CPU *100 = 5.17

Could you please confirm is the above my calculations are correct..?

If it correct then

How to find CPU taken by non oracle process from awr report?
How to find CPU %IDLE time from awr report..?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2015

Added on Dec 20 2014

#general-database-discussions

14 comments

3,004 views