Re: Where the heck is DBMS_SHARED_POOL ?

Robert Chin wrote:
>
> I don't see this package DBMS_SHARED_POOL under SYS schema on
> 8.0.5 and 8.1.6
> This is supposed to be where you can invoke KEEP to pin pkgs in the SGA
> etc right ?
>
> Thanks all
> robert

Hello Robert,
in 8.1.6/8.1.7 the package is not created automatically when you run catproc.sql after 'create database...'. For 8.0.5 I don't know, haven't worked with this version.
The following URL provides further information, please take a look at http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_sha.htm#999107

Location of dbmsspool.sql: $ORACLE_HOME/rdbms/admin

Kind Regards
Manuela Mueller Received on Sun Nov 04 2001 - 15:09:18 CST