Re: Library Cache

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 5 Dec 2001 19:54:37 +1100
Message-ID: <3c0de0ce$0$27915$afc38c87@news.optusnet.com.au>

Alter system flush shared_pool;

And yes, the impact on a running database will be significant in terms of performance: all existing execution plans, procedures, triggers, functions and sequences will be flushed (unless they are kept in the library cache using the dbms_shared_pool.keep procedure).

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Prakash C N" <prakashcn_at_hotmail.com> wrote in message
news:7e1c2f8c.0112042359.24f4eaad_at_posting.google.com...


> Hi

>

>    Can i clear the library cache, if yes, how can i do this

>    will ther be any impact on the database/instance running,

>

>  -Regards,

>   Prakash

Received on Wed Dec 05 2001 - 02:54:37 CST