RE: Three is the number, the number shall be three ...

I do remember sitting through an Oracle Fundamentals class (for Version 8) where the instructor said that If you wish to completely flush the shared pool (pinned objects and all) then you must issue the flush shared_pool command 3 times in fairly quick succession.

Lees than the three and it will only flush the parsed SQL .. PL/SQL

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shrek Sent: Monday, November 29, 2004 1:53 PM
To: bdbafh_at_gmail.com
Cc: Oracle-L (E-mail)
Subject: Re: Three is the number, the number shall be three ...

On Mon, 29 Nov 2004 14:45:54 -0500, Paul Drake <bdbafh_at_gmail.com> wrote:
> Might anyone care to wager why a developer at Oracle would use 3
> iterations of flushing the shared_pool during execution of the
> jserver.sql script in creation of the JServer subsequent to database
> creation?

old unix habit of "sync sync sync"?

--=20

--
Bill "Shrek" Thater     ORACLE DBA    =20
       shrekdba_at_gmail.com=20
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l