DBA Data[Home] [Help]

VIEW: SYS.V_$RSRC_PLAN

Source

View Text - Preformatted

select "ID","NAME","IS_TOP_PLAN","CPU_MANAGED","INSTANCE_CAGING","PARALLEL_SERVERS_ACTIVE","PARALLEL_SERVERS_TOTAL","PARALLEL_EXECUTION_MANAGED","CON_ID","DIRECTIVE_TYPE","SHARES","UTILIZATION_LIMIT","PARALLEL_SERVER_LIMIT","MEMORY_MIN","MEMORY_LIMIT","PROFILE" from v$rsrc_plan
View Text - HTML Formatted

SELECT "ID"
, "NAME"
, "IS_TOP_PLAN"
, "CPU_MANAGED"
, "INSTANCE_CAGING"
, "PARALLEL_SERVERS_ACTIVE"
, "PARALLEL_SERVERS_TOTAL"
, "PARALLEL_EXECUTION_MANAGED"
, "CON_ID"
, "DIRECTIVE_TYPE"
, "SHARES"
, "UTILIZATION_LIMIT"
, "PARALLEL_SERVER_LIMIT"
, "MEMORY_MIN"
, "MEMORY_LIMIT"
, "PROFILE"
FROM V$RSRC_PLAN