RE: parse to execute ration

You are correct. The text that you have quoted is absurd.  

If there is one parse per execute, it's bad. THIS is a clue that you're not using bind variables.  

If there is more than one parse per execute, it's absurd. (That doesn't mean you won't see it, though.)  

Less than one parse per execute is the goal.  

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day <http://www.darc.com/ncoaug/> , Aug 16 Chicago

• Miracle Database Forum <http://www.miracleas.dk> , Sep 20-22 Middlefart Denmark
• 2003 Hotsos Symposium <http://www.hotsos.com> on OracleR System Performance, Feb 9-12 Dallas

-----Original Message-----
Sent: Thursday, August 01, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L  

Parse/Execution Ratio

Number of parses divided by the number executions per statement.

Individual number of parses.

Number of executions.

The count of parses to executions should be as close to one as possible. If there are a high number of parses per execution then the statement has been needlessly reparsed. This could indicate the lack of use of bind variables in SQL statements or poor cursor reuse.    

Hi list ,

In oracle doc it says parse to execute ratio is to be close to one . I dont understand that . I thought there should be more executes per parse . So it should be close to 0.

am I wrong ?

Thanks ,

bp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).