Re: sys.dbms_shared

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 20 Apr 1999 14:29:29 -0700
Message-ID: <371CF1B9.B85D3039@us.oracle.com>

Dinesh

DBMS_SHARED_POOL is created by running two files - dbmspool.sql and prvtpool.plb, in that order (they create the package header and package body respectively). The files are located under $ORACLE_HOME/rdbms/admin, and need to be run by SYS. Not sure where they're called from normally, but if you don't have them, running those two scripts will create them.

No they won't be created by a full import. A full export does not export objects owned by SYS, hence the definitions aren't in the dump file to be read.

HTH. Pete

dfp1 wrote:

> Hi,
>
> I have 2 databases TEST and PROD. PROD was created with the same physical
> characteristics as TEST and a full export from TEST was imported into PROD.
>
> However I cannot find the package DBMS_SHARED_POOL package which exists in
> the SYS schema of TEST under packages, in PROD.
>
> At what point in database creation does this package get loaded, or is it
> accomplished by a script such as CATPROC? Wouldn't the full import have
> brought it over anyway? How can I laod it now?
>
> Thanks,
> Dinesh

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Apr 20 1999 - 16:29:29 CDT

Re: sys.dbms_shared_pool