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