Re: dbms_shared_pool.keep?

From: Robin Parker <parkerr_at_logica.com>
Date: 1996/12/07
Message-ID: <parkerr.249.000EBA84@logica.com>#1/1

In article <32A851E2.510A_at_ei.org> benjamin zhang <bzhang_at_ei.org> writes:

>hi,

>How can I run dbms_shared_pool.keep?

>I got this message:
> *
>ERROR at line 1:
>ORA-06550: line 1, column 7:
>PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored

I assume that you've run the $ORACLE_HOME/rdbms/admin/dbmspool.sql script. You don't say what version of the RDBMS you are using, but there is a problem with the script in 7.3.

What you need to do to get around the problem is to create a file (in rdbms/admin) with just the line :-

@@prvtpool.plb

Then run this from svrmgr.

Robin Parker Received on Sat Dec 07 1996 - 00:00:00 CST