Never mind I found out why
:
As system I was supposed to
EXECUTE sys.DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ;
- Original Message -----
From: <bulbultyagi_at_now-india.net.in>
To: <ORACLE-L_at_fatcity.com>
Sent: Friday, July 25, 2003 21:42
Subject: DBMS_SHARED_POOL
> 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.
Received on Fri Jul 25 2003 - 15:55:52 CDT
