DBMS_SHARED

From: <bulbultyagi_at_now-india.net.in>
Date: Fri, 25 Jul 2003 21:42:47 +0530
Message-Id: <26013.339631@fatcity.com>

Hello list,
1. Can the following statement be executed sucessfully only by the sysdba ?

EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD (25165824 ) ; 2. ?\rdbms\admin\dbmspool.sql creates dbms_shared_pool . And it explicitly
grants execute on dbms_shared_pool to execute_catalog_role. Still I cannot run the above statement when connected as system/manager on my 9.2.0.1.0 enterprise edn on windows.
I get the following errors :

SQL> sho user
USER is "SYSTEM"

SQL> EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ; BEGIN DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 31457280 ) ; END; *
ERROR at line 1:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYSTEM.DBMS_SHARED_POOL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

3. However When I run as sysdba, no problems

SQL> sho user
USER is "SYS"
SQL> EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ; PL/SQL procedure successfully completed.

Any ideas ? Received on Fri Jul 25 2003 - 11:12:47 CDT