Re: flush shared_pool?

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.