Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Where the heck is DBMS_SHARED_POOL ?

Re: Where the heck is DBMS_SHARED_POOL ?

From: Robert Chin <chinman_at_optonline.net>
Date: Tue, 06 Nov 2001 05:02:02 GMT
Message-ID: <e9KF7.40867$D7.10021111@news02.optonline.net>


danke schoen....

"Manuela Mueller" <520040906697-0001_at_t-online.de> wrote in message news:3BE5B083.197DF4AC_at_t-online.de...
> 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 Mon Nov 05 2001 - 23:02:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US