prakashcn_at_hotmail.com (Prakash C N) 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
Generally, The Oracle rdbms will manage the library cache and it does
not give the DBA many tools or options to change how the cache is
managed. The command 'alter system flush shared pool' will clear sql
and control information that is not currently in use from the shared
pool. Other than increasing the size of the shared pool there isn't a
whole lot that the DBA can do in this area other than tune SQL so that
it is not being ran in a way that causes excessive demands on the
shared pool and buffer cache.
Received on Wed Dec 05 2001 - 08:12:19 CST
