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 ? .................... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
