DBMS_SHARED_POOL package创建

SQL> desc DBMS_SHARED_POOL
Object DBMS_SHARED_POOL does not exist.

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

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