Re: Execute to Parse %:

The Soft Parse % is 99.09, and the other numbers do say the instance is doing mostly soft parses. I thought the Execute to Parse Ratio measured (Hard Parses / Executions). If this ratio is (Hard Parse + Soft Parse) / Executions then I am not so concerned.

I do have 2 of Tom's books. When talking about parsing, he mainly says use bind variables and avoid the hard parse so the application can scale. I don't fully understand how a cursor can be executed without first being at least soft parsed.

In what circumstance will the instance not hard or soft parse and just execute? When the cursor is found in the cursor cache? What is Execute to Parse Ratio really measuring? Received on Fri Jul 01 2005 - 07:32:52 CDT