SQL> exec DBMS_SHARED_POOL.KEEP('STANDARD','P');
BEGIN DBMS_SHARED_POOL.KEEP('STANDARD','P'); END;

      *
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

查看是否安装了DBMS_SHARED_POOL包

SQL> select count(*) from DBA_OBJECTS where object_name='DBMS_SHARED_POOL';

  COUNT(*)
----------
         0

安装DBMS_SHARED_POOL包

SQL> @?/rdbms/admin/dbmspool.sql

Package created.


Grant succeeded.


View created.


Package body created.

验证

SQL> select count(*) from DBA_OBJECTS where object_name='DBMS_SHARED_POOL';

  COUNT(*)
----------
         2

SQL> exec DBMS_SHARED_POOL.KEEP('STANDARD','P');

PL/SQL procedure successfully completed.