RE: Parse to execute Ratio

When parsed the package/statement is brought in to a buffer, then executed. If flushed afterwards, and called again, it will have to be re parsed, then executed again. If not flushed, it is already parsed, so just executes again.

If you have a high number of parses and executes, this means that it is constantly being flushed, and reparsed for a new execution. This takes I/O so *can* be a problem depending on the size of the package, and I/O manifests itself as an increase in end user response times. If you have a very high number of executions, it may worth pinning the package to your buffer pool, to keep it from being flushed from memory.

The worst case would be if every time it is executed, it is parsed as well - a 1 to 1 relationship. In considering whether to pin it or not you should also consider the number of executions - there is no real benefit in pinning a statement run once a day.

HTH Mark

-----Original Message-----
Kostyszyn
Sent: Wednesday, February 14, 2001 07:46 To: Multiple recipients of list ORACLE-L

Hi all,

        What exactly does this mean and how can I reduce it? What is considered high?

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

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).