Manuela Mueller wrote:
>
> 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
oops,
was too fast on my keyboard, script name is dbmspool.sql
Manuela Mueller
Received on Sun Nov 04 2001 - 15:17:55 CST
