Database Tuning (MOSC)

MOSC Banner

CPU Metrics in ASH and AWR report

edited May 13, 2009 9:51PM in Database Tuning (MOSC) 4 commentsAnswered
 In running an ASH and AWR reports, we are trying to determine the percentage of CPU a given service is consuming on our server.  For example, if for a 1 hour period, our OS reports state the database server was 60% CPU, and we have 3 Oracle services running within the database we want to find the metric in either AWR or ASH which would state

Service X - 40% CPU usage in Database

Service Y - 50% CPU usage in Database

Service Z - 10% CPU usage in Database

Therefore we can say Service X = (0.6 OS CPU used) * (0.4 CPU use in DB) = .24 = 24% of OS CPU was consumed by service X.  AWR provides service stats such as "DB CPU(s)" - Is this the number of seconds of CPU used?  If we had stats for "DB CPU(s)" as

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center