Database Resource Manager


       set echo on;  

       set linesize 300;   

       set pages 1000;   

       set numwidth 10;   

       set trimspool on;   

       col VALUE for a30;   

       col ATTRIBUTE for a15;   

       col GRANTEE for a25;   

       col CPU_METHOD for a15;   

       col COMMENTS for a30;   

       col MGMT_METHOD for a15;  

       col STATUS for a10;  

       alter session set nls_date_format='yyyy/mm/dd hh24:mi:ss';  

       set markup html on  

       spool resource_manager_details.html 
 
       show parameter resource  

       SELECT SYSDATE FROM DUAL;  

       SELECT * FROM DBA_RSRC_MANAGER_SYSTEM_PRIVS; 
 
       SELECT * FROM DBA_RSRC_CONSUMER_GROUP_PRIVS; 

       SELECT * FROM DBA_RSRC_CONSUMER_GROUPS;  

       SELECT * FROM DBA_RSRC_PLANS;  

       SELECT * FROM DBA_RSRC_PLAN_DIRECTIVES; 
 
       SELECT * FROM V$RSRC_CONSUMER_GROUP;  

       select * from dba_rsrc_group_mappings;  

       select * from dba_rsrc_mapping_priority;  

       select username, resource_consumer_group, service_name from v$session; 

       SELECT * FROM V$RSRC_CONSUMER_GROUP_CPU_MTH;  

       SELECT * FROM V$RSRC_PLAN;  

       SELECT * FROM V$RSRC_PLAN_CPU_MTH; 
 
       SELECT * FROM V$RSRC_CONS_GROUP_HISTORY; 

       SELECT * FROM V$RSRC_PLAN_HISTORY; 

       SELECT * FROM V$RSRC_SESSION_INFO; 

       spool off  

       set markup html off
HOME