column plan format a20
column SWITCH_GROUP format a15
column GROUP_OR_SUBPLAN format a17
column VALUE format a20

select plan,GROUP_OR_SUBPLAN,type,cpu_p1,SWITCH_GROUP,SWITCH_ESTIMATE SW_EST,switch_for_call SWFC,SWITCH_TIME ,SWITCH_TIME_IN_CALL SWT_CALL,MAX_IDLE_TIME IDLE_TIME,MAX_IDLE_BLOCKER_TIME IDLE_BLOCKER_TIME,ACTIVE_SESS_POOL_P1 ASP
from DBA_RSRC_PLAN_DIRECTIVES
where plan like upper('&1')
order by plan,GROUP_OR_SUBPLAN;

select ATTRIBUTE,VALUE,CONSUMER_GROUP,STATUS from DBA_RSRC_GROUP_MAPPINGS order by ATTRIBUTE,CONSUMER_GROUP, value;

select grantee,granted_group,grant_option,initial_group from DBA_RSRC_CONSUMER_GROUP_PRIVS order by grantee,granted_group;
