Oracle-L: RE: Flush Shared Pool Area

From: <John.Hallas_at_vodafone.co.uk>
Date: Tue, 25 Jun 2002 03:08:27 -0800
Message-ID: <F001.004865D6.20020625030827@fatcity.com>

Normally this is done when you are getting ORA-4030 (maybe ORA-4031 as well) errors.
Basically the shared pool is fragmented and a object is trying to load but cannot find sufficient contiguous free space. Flushing the shared pool clears everything out and the package should load. Bear in mind that when flushing the shared pool any objects that are marked as kept will not be flushed out.
It is normal to load often used packages into the shared pool just after startup so that these are kept and space is used efficiently.

HTH John

-----Original Message-----
Sent: 25 June 2002 11:03
To: Multiple recipients of list ORACLE-L

Hi All

In which cases the "alter system flush shared_pool" is necessary ?

Regards
Kamel Benlatreche

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: GL2Z/ INF DBA BENLATRECHE
INET: kbenlatreche_at_lth.sonatrach.dz

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:
INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------