column plan format a15
column SWITCH_GROUP format a15
column GROUP_OR_SUBPLAN format a17
column VALUE format a20
column SW_EST format a6
column SW_CALL format a7

select plan,GROUP_OR_SUBPLAN,SWITCH_FOR_CALL SW_CALL, SWITCH_IO_MEGABYTES SW_IO_MB,cpu_p1,SWITCH_GROUP,SWITCH_ESTIMATE SW_EST,SWITCH_TIME_IN_CALL SW_TIME_CALL,MAX_IDLE_TIME,MAX_IDLE_BLOCKER_TIME,ACTIVE_SESS_POOL_P1 ASP
from DBA_RSRC_PLAN_DIRECTIVES
where plan = 'RESMANAGERDGA'
order by GROUP_OR_SUBPLAN;

