Re: flushing the shared pool

Not everything is actually flushed out when you do the dreadful flush shared pool thing.

Mogens

David Turner wrote:

>I'm curious, we have a database with a canned app that isn't using bind variables.
>Periodically we flush the shared pool when the cache fills up with these statements.
>But I've noticed it takes much longer to fill up after a shutdown than it does a
>flush. What's the difference? We aren't pinning anything.
>
>Dave
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).