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.
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:
Post a Comment