PARSE CPU TO PARSE ELAPSED % HAVE YOU EVER HESITATED AND SKIPPED THIS METRIC IN AWR REPORT ? ORACLE

In AWR report, there is a field in Instance efficiency % called Parse CPU to Parse Elapsd% which in most of the cases lead us to scepticism and skip this metric

To directly come to the point, this metric is related to calculation of efficiency of parsing of the SQL statements using CPU

The amount of CPU time that is spent on parsing or waiting on an event to parse (ie)

For every second of CPU , the amount of clock time spent in parsing or waiting by database

Higher the ratio better the instance efficiency which means CPU time = Parse time ==>(Efficiency = 100%) and CPU is effectively used for parsing itself which is its purpose

Lower the ratio, which means SQL is waiting on some events latch or mutex to parse which is not good.

Example: As the ratio in itself says, ( parse time cpu / parse time elapsed ) * 100

=>

( 12527/401081 ) * 100 = ~3.12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s