Re: Question about DBMS_SHARED_POOL package
From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Mon, 3 Mar 2003 10:08:10 -0600
Message-ID: <L5L8a.9$G_.19107_at_news.uswest.net>
Date: Mon, 3 Mar 2003 10:08:10 -0600
Message-ID: <L5L8a.9$G_.19107_at_news.uswest.net>
DBMS_SHARED_POOL only operates on the following object types: packages, procedures, functions, types, triggers, sequences, and SQL cursors. I believe that, in spite of the name DBMS_SHARED_POOL, it only works with objects in the library cache (shared SQL and PL/SQL areas).
Hope this helps!
-- Cheers, Chris ___________________________________ Chris Leonard, The Database Guy http://www.databaseguy.com Brainbench MVP for Oracle Admin http://www.brainbench.com MCSE, MCDBA, OCP, CIW ___________________________________ "Mike" <mikea_730_at_yahoo.com> wrote in message news:39f5fc53.0302271648.4c12c84a_at_posting.google.com...Received on Mon Mar 03 2003 - 17:08:10 CET
> According to the Oracle docs purpose of the DBMS_SHARED_POOL package
> is to allow access to the shared pool to display sizes of objects and
> to "KEEP" objects to avoid shared pool fragmentation.
>
> From what I can determine this package primarily manipulates the
> "Library Cache" for listing, pinning (KEEPING) objects. How are the
> other components of the shared pool effected? I assume it must effect
> the Dictionary cache also (or some other shared pool components)
> otherwise the package would be called "DBMS_LIBRARY_CACHE.(KEEP|SIZE,
> etc..)
>
> Just courious if anyone knows the details on this.
>
> Thanks!!!
> Mike
>