SQL> desc DBMS_SHARED_POOL
Object DBMS_SHARED_POOL does not exist.

想用一下DBMS_SHARED_POOL.keep，数据库报上面的错误，这个包居然没安装。。。

[@more@]SQL> desc DBMS_SHARED_POOL
Object DBMS_SHARED_POOL does not exist.

SQL> @D:oracleproduct10.2.0db_1RDBMSADMINdbmspool.sql

Package created

Grant succeeded

View created

Package body created

SQL> @D:oracleproduct10.2.0db_1RDBMSADMINprvtpool.plb

View created

Package body created

SQL> desc DBMS_SHARED_POOL;
Element Type
------------------------- ---------
SIZES PROCEDURE
KEEP PROCEDURE
UNKEEP PROCEDURE
PURGE PROCEDURE
ABORTED_REQUEST_THRESHOLD PROCEDURE

ITPub博客

DBMS_SHARED_POOL package创建

最新文章