Re: flush shared_pool?

In article <90qpi6$f8e$1_at_nnrp1.deja.com>,   sybrandb_at_my-deja.com wrote:
> In article <90qlhv$c2s$1_at_nnrp1.deja.com>,
> letokai_at_my-deja.com wrote:
> > What does this command do exactly :
> >
> > alter system flush shared_pool?
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> It clears the library cache, the dictionary cache, and the sql area,
 it
> also flushes any stored procedures from memory and unpins the pinned
> ones.
> Check out the sql reference manual or the server administrators guide.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ----------------------------------------------------------------------
 --
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Hi,

   I don't think it uppins the pinned ones. Thanks and Regards,
Ashish

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 08 2000 - 08:41:20 CST