Re: statspack report shows low execute to parse%

Parse CPU to Parse Elapsed = 1.48%

Doesn't this tell us that while parsing
for every 68 seconds (over 1 minute) only 1 second was used for parsing ?

If thats true then rest of the time must have been spent while waiting on latches

library cache(in case of soft parses)
shared_pool latch (in case of hard parses)

even then it is not sufficient to say whether it is hard parsing a lot or over soft parsing Received on Tue Sep 06 2005 - 08:46:02 CDT