Tuesday 18 September 2012

PLS-00201: identifier 'DBMS_SHARED_POOL.PURGE' must be declared

I wanted to flush the single sql from shared pool and i have fire the below statement but got the below error:


SQL> EXECUTE DBMS_SHARED_POOL.PURGE ('000000053F872000, 2083103143', 'C');
BEGIN DBMS_SHARED_POOL.PURGE ('000000053F872000, 2083103143', 'C'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SHARED_POOL.PURGE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



to declare the DBMS_SHARED_POOL.PURGE you have to run dbmspool.sql under ORACLE_HOME/rdbms/admin/directory



SQL> ?/rdbms/admin/dbmspool.sql
SP2-0172: No HELP matching this topic was found.
SQL> @?/rdbms/admin/dbmspool.sql

Package created.


Grant succeeded.


View created.


Package body created.

SQL> EXECUTE DBMS_SHARED_POOL.PURGE ('000000053F872000, 2083103143', 'C');

PL/SQL procedure successfully completed.

No comments: