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 with CPU

The amount of CPU time by SQL 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 there is a parsing issue (application not reuse the SQL) in the database or 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