SQL ScriptDatabase Resource Manager Configuration |
This script lists the configuration of the Database Resource Manager
None.
col plan form a12 heading "Plan Name" col group_or_subplan form a12 heading "Sub-Plan" col status form a6 heading "Status" col cpu_p1 form 999 heading "CPU1" col cpu_p2 form 999 heading "CPU2" col cpu_p3 form 999 heading "CPU3" col cpu_p4 form 999 heading "CPU4" PROMPT PROMPT Plans on database select plan, cpu_method, status from dba_rsrc_plans; PROMPT PROMPT Resource Plan Directives select plan, group_or_subplan, type, cpu_p1, cpu_p2, cpu_p3, cpu_p4, status from dba_rsrc_plan_directives order by 8,1,2,3,4,5,6; PROMPT PROMPT Consumer Group Privileges select * from dba_rsrc_consumer_group_privs; PROMPT PROMPT Default User Consumer Groups select username, initial_rsrc_consumer_group from dba_users;
Return to Index of SQL Scripts
Home
|
Company Profile
|
Services
|
Contact Us
|
SQL scripts and tips
|
Quiz
|