Parse to execute ratio

[hemanr]

Hi gurus,
What is the 'Parse to execute ratio?'

What does it mean if it is high? say a value of 279.99 ?

Thanks!

[birdax1]

Execute/Parse Ratio:
Normally the number of parses should be low and executions should be high. If this ratio is greater than 1, it means that the same cursor is parsed more than once. A value lower than 1 means that not all opened cursors have been parsed yet. Parsing the same cursor again and again will consume CPU and other resources. There is no need to parse the same cursor again for each execute. The re-parsing normally happens when cursor cache which is configured too small. Making the cursor cache in the application larger will reduce the reparsing. Setting the SESSION_CACHED_CURSORS parameter (start with a value of 100), will reduce contention during parsing.

[birdax1]

A query used to monitor the rate of change in hard parsing is:

select b.name, b.value hard, a.value total, a.value-b.value soft, round((b.value/(a.value))*100,3) "Hard Parse Pct"
from v$sysstat a, v$sysstat b
where a.name = 'parse count (total)'
and b.name = 'parse count (hard)'

[hemanr]

thanks for the info birdax!