61.解析数据库资源管理器
1.Oracle11g资源管理
2.Oracle12c CDB的资源管理
sys@ORCL 2023-03-13 20:51:51> desc dbms_resource_manager;
PROCEDURE BEGIN_SQL_BLOCK
PROCEDURE CALIBRATE_IO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NUM_PHYSICAL_DISKS BINARY_INTEGER IN DEFAULT
MAX_LATENCY BINARY_INTEGER IN DEFAULT
MAX_IOPS BINARY_INTEGER OUT
MAX_MBPS BINARY_INTEGER OUT
ACTUAL_LATENCY BINARY_INTEGER OUT
PROCEDURE CLEAR_PENDING_AREA
PROCEDURE CREATE_CATEGORY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CATEGORY VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
PROCEDURE CREATE_CDB_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
PROCEDURE CREATE_CDB_PLAN_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PLUGGABLE_DATABASE VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
SHARES NUMBER IN DEFAULT
UTILIZATION_LIMIT NUMBER IN DEFAULT
PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
MEMORY_MIN NUMBER IN DEFAULT
MEMORY_LIMIT NUMBER IN DEFAULT
PROCEDURE CREATE_CDB_PROFILE_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PROFILE VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
SHARES NUMBER IN DEFAULT
UTILIZATION_LIMIT NUMBER IN DEFAULT
PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
MEMORY_MIN NUMBER IN DEFAULT
MEMORY_LIMIT NUMBER IN DEFAULT
PROCEDURE CREATE_CONSUMER_GROUP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONSUMER_GROUP VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
CPU_MTH VARCHAR2 IN DEFAULT
MGMT_MTH VARCHAR2 IN DEFAULT
CATEGORY VARCHAR2 IN DEFAULT
PROCEDURE CREATE_PENDING_AREA
PROCEDURE CREATE_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
CPU_MTH VARCHAR2 IN DEFAULT
ACTIVE_SESS_POOL_MTH VARCHAR2 IN DEFAULT
PARALLEL_DEGREE_LIMIT_MTH VARCHAR2 IN DEFAULT
QUEUEING_MTH VARCHAR2 IN DEFAULT
MGMT_MTH VARCHAR2 IN DEFAULT
SUB_PLAN BOOLEAN IN DEFAULT
MAX_IOPS NUMBER IN DEFAULT
MAX_MBPS NUMBER IN DEFAULT
PROCEDURE CREATE_PLAN_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
GROUP_OR_SUBPLAN VARCHAR2 IN
COMMENT VARCHAR2 IN DEFAULT
CPU_P1 NUMBER IN DEFAULT
CPU_P2 NUMBER IN DEFAULT
CPU_P3 NUMBER IN DEFAULT
CPU_P4 NUMBER IN DEFAULT
CPU_P5 NUMBER IN DEFAULT
CPU_P6 NUMBER IN DEFAULT
CPU_P7 NUMBER IN DEFAULT
CPU_P8 NUMBER IN DEFAULT
ACTIVE_SESS_POOL_P1 NUMBER IN DEFAULT
QUEUEING_P1 NUMBER IN DEFAULT
PARALLEL_DEGREE_LIMIT_P1 NUMBER IN DEFAULT
SWITCH_GROUP VARCHAR2 IN DEFAULT
SWITCH_TIME NUMBER IN DEFAULT
SWITCH_ESTIMATE BOOLEAN IN DEFAULT
MAX_EST_EXEC_TIME NUMBER IN DEFAULT
UNDO_POOL NUMBER IN DEFAULT
MAX_IDLE_TIME NUMBER IN DEFAULT
MAX_IDLE_BLOCKER_TIME NUMBER IN DEFAULT
SWITCH_TIME_IN_CALL NUMBER IN DEFAULT
MGMT_P1 NUMBER IN DEFAULT
MGMT_P2 NUMBER IN DEFAULT
MGMT_P3 NUMBER IN DEFAULT
MGMT_P4 NUMBER IN DEFAULT
MGMT_P5 NUMBER IN DEFAULT
MGMT_P6 NUMBER IN DEFAULT
MGMT_P7 NUMBER IN DEFAULT
MGMT_P8 NUMBER IN DEFAULT
SWITCH_IO_MEGABYTES NUMBER IN DEFAULT
SWITCH_IO_REQS NUMBER IN DEFAULT
SWITCH_FOR_CALL BOOLEAN IN DEFAULT
MAX_UTILIZATION_LIMIT NUMBER IN DEFAULT
PARALLEL_TARGET_PERCENTAGE NUMBER IN DEFAULT
PARALLEL_QUEUE_TIMEOUT NUMBER IN DEFAULT
PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
UTILIZATION_LIMIT NUMBER IN DEFAULT
SWITCH_IO_LOGICAL NUMBER IN DEFAULT
SWITCH_ELAPSED_TIME NUMBER IN DEFAULT
SHARES NUMBER IN DEFAULT
PARALLEL_STMT_CRITICAL VARCHAR2 IN DEFAULT
SESSION_PGA_LIMIT NUMBER IN DEFAULT
PROCEDURE CREATE_SIMPLE_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SIMPLE_PLAN VARCHAR2 IN DEFAULT
CONSUMER_GROUP1 VARCHAR2 IN DEFAULT
GROUP1_CPU NUMBER IN DEFAULT
CONSUMER_GROUP2 VARCHAR2 IN DEFAULT
GROUP2_CPU NUMBER IN DEFAULT
CONSUMER_GROUP3 VARCHAR2 IN DEFAULT
GROUP3_CPU NUMBER IN DEFAULT
CONSUMER_GROUP4 VARCHAR2 IN DEFAULT
GROUP4_CPU NUMBER IN DEFAULT
CONSUMER_GROUP5 VARCHAR2 IN DEFAULT
GROUP5_CPU NUMBER IN DEFAULT
CONSUMER_GROUP6 VARCHAR2 IN DEFAULT
GROUP6_CPU NUMBER IN DEFAULT
CONSUMER_GROUP7 VARCHAR2 IN DEFAULT
GROUP7_CPU NUMBER IN DEFAULT
CONSUMER_GROUP8 VARCHAR2 IN DEFAULT
GROUP8_CPU NUMBER IN DEFAULT
GROUP1_PERCENT NUMBER IN DEFAULT
GROUP2_PERCENT NUMBER IN DEFAULT
GROUP3_PERCENT NUMBER IN DEFAULT
GROUP4_PERCENT NUMBER IN DEFAULT
GROUP5_PERCENT NUMBER IN DEFAULT
GROUP6_PERCENT NUMBER IN DEFAULT
GROUP7_PERCENT NUMBER IN DEFAULT
GROUP8_PERCENT NUMBER IN DEFAULT
PROCEDURE DELETE_CATEGORY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CATEGORY VARCHAR2 IN
PROCEDURE DELETE_CDB_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PROCEDURE DELETE_CDB_PLAN_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PLUGGABLE_DATABASE VARCHAR2 IN
PROCEDURE DELETE_CDB_PROFILE_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PROFILE VARCHAR2 IN
PROCEDURE DELETE_CONSUMER_GROUP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONSUMER_GROUP VARCHAR2 IN
PROCEDURE DELETE_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PROCEDURE DELETE_PLAN_CASCADE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PROCEDURE DELETE_PLAN_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
GROUP_OR_SUBPLAN VARCHAR2 IN
PROCEDURE DEQUEUE_PARALLEL_STATEMENT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SESSION_ID BINARY_INTEGER IN
SESSION_SERIAL BINARY_INTEGER IN
INST_ID BINARY_INTEGER IN DEFAULT
SQL_ID VARCHAR2 IN DEFAULT
PROCEDURE END_SQL_BLOCK
PROCEDURE SET_CONSUMER_GROUP_MAPPING
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
ATTRIBUTE VARCHAR2 IN
VALUE VARCHAR2 IN
CONSUMER_GROUP VARCHAR2 IN DEFAULT
PROCEDURE SET_CONSUMER_GROUP_MAPPING_PRI
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EXPLICIT NUMBER IN
ORACLE_USER NUMBER IN
SERVICE_NAME NUMBER IN
CLIENT_OS_USER NUMBER IN
CLIENT_PROGRAM NUMBER IN
CLIENT_MACHINE NUMBER IN
MODULE_NAME NUMBER IN
MODULE_NAME_ACTION NUMBER IN
SERVICE_MODULE NUMBER IN
SERVICE_MODULE_ACTION NUMBER IN
CLIENT_ID NUMBER IN DEFAULT
PROCEDURE SET_INITIAL_CONSUMER_GROUP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
USER VARCHAR2 IN
CONSUMER_GROUP VARCHAR2 IN
PROCEDURE SUBMIT_PENDING_AREA
PROCEDURE SWITCH_CONSUMER_GROUP_FOR_SESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SESSION_ID NUMBER IN
SESSION_SERIAL NUMBER IN
CONSUMER_GROUP VARCHAR2 IN
PROCEDURE SWITCH_CONSUMER_GROUP_FOR_USER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
USER VARCHAR2 IN
CONSUMER_GROUP VARCHAR2 IN
PROCEDURE SWITCH_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN_NAME VARCHAR2 IN
SID VARCHAR2 IN DEFAULT
ALLOW_SCHEDULER_PLAN_SWITCHES BOOLEAN IN DEFAULT
PROCEDURE UPDATE_CATEGORY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CATEGORY VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
PROCEDURE UPDATE_CDB_AUTOTASK_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_SHARES NUMBER IN DEFAULT
NEW_UTILIZATION_LIMIT NUMBER IN DEFAULT
NEW_PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
NEW_MEMORY_MIN NUMBER IN DEFAULT
NEW_MEMORY_LIMIT NUMBER IN DEFAULT
PROCEDURE UPDATE_CDB_DEFAULT_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_SHARES NUMBER IN DEFAULT
NEW_UTILIZATION_LIMIT NUMBER IN DEFAULT
NEW_PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
NEW_MEMORY_MIN NUMBER IN DEFAULT
NEW_MEMORY_LIMIT NUMBER IN DEFAULT
PROCEDURE UPDATE_CDB_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
PROCEDURE UPDATE_CDB_PLAN_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PLUGGABLE_DATABASE VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_SHARES NUMBER IN DEFAULT
NEW_UTILIZATION_LIMIT NUMBER IN DEFAULT
NEW_PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
NEW_MEMORY_MIN NUMBER IN DEFAULT
NEW_MEMORY_LIMIT NUMBER IN DEFAULT
PROCEDURE UPDATE_CDB_PROFILE_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
PROFILE VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_SHARES NUMBER IN DEFAULT
NEW_UTILIZATION_LIMIT NUMBER IN DEFAULT
NEW_PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
NEW_MEMORY_MIN NUMBER IN DEFAULT
NEW_MEMORY_LIMIT NUMBER IN DEFAULT
PROCEDURE UPDATE_CONSUMER_GROUP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CONSUMER_GROUP VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_CPU_MTH VARCHAR2 IN DEFAULT
NEW_MGMT_MTH VARCHAR2 IN DEFAULT
NEW_CATEGORY VARCHAR2 IN DEFAULT
PROCEDURE UPDATE_PLAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_CPU_MTH VARCHAR2 IN DEFAULT
NEW_ACTIVE_SESS_POOL_MTH VARCHAR2 IN DEFAULT
NEW_PARALLEL_DEGREE_LIMIT_MTH VARCHAR2 IN DEFAULT
NEW_QUEUEING_MTH VARCHAR2 IN DEFAULT
NEW_MGMT_MTH VARCHAR2 IN DEFAULT
NEW_SUB_PLAN BOOLEAN IN DEFAULT
NEW_MAX_IOPS NUMBER IN DEFAULT
NEW_MAX_MBPS NUMBER IN DEFAULT
PROCEDURE UPDATE_PLAN_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PLAN VARCHAR2 IN
GROUP_OR_SUBPLAN VARCHAR2 IN
NEW_COMMENT VARCHAR2 IN DEFAULT
NEW_CPU_P1 NUMBER IN DEFAULT
NEW_CPU_P2 NUMBER IN DEFAULT
NEW_CPU_P3 NUMBER IN DEFAULT
NEW_CPU_P4 NUMBER IN DEFAULT
NEW_CPU_P5 NUMBER IN DEFAULT
NEW_CPU_P6 NUMBER IN DEFAULT
NEW_CPU_P7 NUMBER IN DEFAULT
NEW_CPU_P8 NUMBER IN DEFAULT
NEW_ACTIVE_SESS_POOL_P1 NUMBER IN DEFAULT
NEW_QUEUEING_P1 NUMBER IN DEFAULT
NEW_PARALLEL_DEGREE_LIMIT_P1 NUMBER IN DEFAULT
NEW_SWITCH_GROUP VARCHAR2 IN DEFAULT
NEW_SWITCH_TIME NUMBER IN DEFAULT
NEW_SWITCH_ESTIMATE BOOLEAN IN DEFAULT
NEW_MAX_EST_EXEC_TIME NUMBER IN DEFAULT
NEW_UNDO_POOL NUMBER IN DEFAULT
NEW_MAX_IDLE_TIME NUMBER IN DEFAULT
NEW_MAX_IDLE_BLOCKER_TIME NUMBER IN DEFAULT
NEW_SWITCH_TIME_IN_CALL NUMBER IN DEFAULT
NEW_MGMT_P1 NUMBER IN DEFAULT
NEW_MGMT_P2 NUMBER IN DEFAULT
NEW_MGMT_P3 NUMBER IN DEFAULT
NEW_MGMT_P4 NUMBER IN DEFAULT
NEW_MGMT_P5 NUMBER IN DEFAULT
NEW_MGMT_P6 NUMBER IN DEFAULT
NEW_MGMT_P7 NUMBER IN DEFAULT
NEW_MGMT_P8 NUMBER IN DEFAULT
NEW_SWITCH_IO_MEGABYTES NUMBER IN DEFAULT
NEW_SWITCH_IO_REQS NUMBER IN DEFAULT
NEW_SWITCH_FOR_CALL BOOLEAN IN DEFAULT
NEW_MAX_UTILIZATION_LIMIT NUMBER IN DEFAULT
NEW_PARALLEL_TARGET_PERCENTAGE NUMBER IN DEFAULT
NEW_PARALLEL_QUEUE_TIMEOUT NUMBER IN DEFAULT
NEW_PARALLEL_SERVER_LIMIT NUMBER IN DEFAULT
NEW_UTILIZATION_LIMIT NUMBER IN DEFAULT
NEW_SWITCH_IO_LOGICAL NUMBER IN DEFAULT
NEW_SWITCH_ELAPSED_TIME NUMBER IN DEFAULT
NEW_SHARES NUMBER IN DEFAULT
NEW_PARALLEL_STMT_CRITICAL VARCHAR2 IN DEFAULT
NEW_SESSION_PGA_LIMIT NUMBER IN DEFAULT
PROCEDURE VALIDATE_PENDING_AREA
sys@ORCL 2023-03-13 20:58:50> exec dbms_resource_manager.clear_pending_area();
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.05
sys@ORCL 2023-03-13 21:00:16> exec dbms_resource_manager.create_pending_area();
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
sys@ORCL 2023-03-13 21:05:04> exec dbms_resource_manager.create_cdb_plan('cdb_plan','cdb - orclpdb01')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
sys@ORCL 2023-03-13 21:05:35> exec dbms_resource_manager.create_cdb_plan_directive('cdb_plan','orclpdb01','',1,80,80);
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
sys@ORCL 2023-03-13 21:07:33> exec dbms_resource_manager.validate_pending_area();
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.03
sys@ORCL 2023-03-13 21:09:21> exec dbms_resource_manager.submit_pending_area();
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.07
sys@ORCL 2023-03-13 21:09:51> show parameter resource;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_limit boolean TRUE
resource_manage_goldengate boolean FALSE
resource_manager_cpu_allocation integer 1
resource_manager_plan string
sys@ORCL 2023-03-13 21:10:16> alter system set resource_manager_plan='cdb_plan';
System altered.
Elapsed: 00:00:00.05
sys@ORCL 2023-03-13 21:10:44> show parameter resource;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
resource_limit boolean TRUE
resource_manage_goldengate boolean FALSE
resource_manager_cpu_allocation integer 1
resource_manager_plan string cdb_plan
sys@ORCL 2023-03-13 21:10:49> select tname from tab where tname like '%PLAN%';
TNAME
--------------------------------------------------------------------------------------------------------------------------------
ALL_SQLSET_PLANS
AWR_PDB_PLAN_OPERATION_NAME
AWR_PDB_PLAN_OPTION_NAME
AWR_PDB_RSRC_PLAN
AWR_PDB_SQL_PLAN
AWR_ROOT_PLAN_OPERATION_NAME
AWR_ROOT_PLAN_OPTION_NAME
AWR_ROOT_RSRC_PLAN
AWR_ROOT_SQL_PLAN
CDB_ADVISOR_SQLPLANS
CDB_CDB_RSRC_PLANS
CDB_CDB_RSRC_PLAN_DIRECTIVES
CDB_HIST_PLAN_OPERATION_NAME
CDB_HIST_PLAN_OPTION_NAME
CDB_HIST_RSRC_PLAN
CDB_HIST_SQL_PLAN
CDB_RESOURCE_PLAN$
CDB_RESOURCE_PLAN_DIRECTIVE$
CDB_ROLLING_PLAN
CDB_RSRC_PLANS
CDB_RSRC_PLAN_DIRECTIVES
CDB_SQLSET_PLANS
CDB_SQLTUNE_PLANS
CDB_SQLTUNE_RATIONALE_PLAN
CDB_SQL_PLAN_BASELINES
CDB_SQL_PLAN_DIRECTIVES
CDB_SQL_PLAN_DIR_OBJECTS
DBA_ADVISOR_SQLPLANS
DBA_CDB_RSRC_PLANS
DBA_CDB_RSRC_PLAN_DIRECTIVES
DBA_HIST_PLAN_OPERATION_NAME
DBA_HIST_PLAN_OPTION_NAME
DBA_HIST_RSRC_PLAN
DBA_HIST_SQL_PLAN
DBA_ROLLING_PLAN
DBA_RSRC_PLANS
DBA_RSRC_PLAN_DIRECTIVES
DBA_SQLSET_PLANS
DBA_SQLTUNE_PLANS
DBA_SQLTUNE_RATIONALE_PLAN
DBA_SQL_PLAN_BASELINES
DBA_SQL_PLAN_DIRECTIVES
DBA_SQL_PLAN_DIR_OBJECTS
GV_$ADVISOR_CURRENT_SQLPLAN
GV_$RSRC_PLAN
GV_$RSRC_PLAN_CPU_MTH
GV_$RSRC_PLAN_HISTORY
GV_$SQLAREA_PLAN_HASH
GV_$SQLSTATS_PLAN_HASH
GV_$SQL_PLAN
GV_$SQL_PLAN_MONITOR
GV_$SQL_PLAN_STATISTICS
GV_$SQL_PLAN_STATISTICS_ALL
KU$_RMGR_PLAN_DIRECT_VIEW
KU$_RMGR_PLAN_VIEW
PLAN_TABLE$
RESOURCE_PLAN$
RESOURCE_PLAN_DIRECTIVE$
SQLOBJ$PLAN
SQLOBJ$PLAN_DATAPUMP
SQLOBJ$PLAN_DATAPUMP_TBL
USER_ADVISOR_SQLPLANS
USER_SQLSET_PLANS
USER_SQLTUNE_PLANS
USER_SQLTUNE_RATIONALE_PLAN
V_$ADVISOR_CURRENT_SQLPLAN
V_$RSRC_PLAN
V_$RSRC_PLAN_CPU_MTH
V_$RSRC_PLAN_HISTORY
V_$SQLAREA_PLAN_HASH
V_$SQLSTATS_PLAN_HASH
V_$SQL_PLAN
V_$SQL_PLAN_MONITOR
V_$SQL_PLAN_STATISTICS
V_$SQL_PLAN_STATISTICS_ALL
WRH$_PLAN_OPERATION_NAME
WRH$_PLAN_OPTION_NAME
WRH$_RSRC_PLAN
WRH$_SQL_PLAN
WRHS$_PLAN_OPERATION_NAME
WRHS$_PLAN_OPTION_NAME
WRHS$_SQL_PLAN
WRI$_ADV_SQLT_PLANS
WRI$_ADV_SQLT_PLAN_HASH
WRI$_ADV_SQLT_PLAN_STATS
WRI$_ADV_SQLT_RTN_PLAN
WRI$_SQLSET_PLANS
WRI$_SQLSET_PLANS_TOCAP
WRI$_SQLSET_PLAN_LINES
WRI$_SQLSET_WORKSPACE_PLANS
90 rows selected.
Elapsed: 00:00:00.17
sys@ORCL 2023-03-13 21:12:20> desc DBA_CDB_RSRC_PLANS
Name Null? Type
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLAN_ID NOT NULL NUMBER
PLAN VARCHAR2(128)
COMMENTS VARCHAR2(2000)
STATUS VARCHAR2(128)
MANDATORY VARCHAR2(3)
sys@ORCL 2023-03-13 21:13:27> select plan_id,plan,status from dba_cdb_rsrc_plans;
PLAN_ID PLAN STATUS
---------- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
19003 DEFAULT_CDB_PLAN
19004 DEFAULT_MAINTENANCE_PLAN
74965 CDB_PLAN
19006 ORA$QOS_CDB_PLAN
19005 ORA$INTERNAL_CDB_PLAN
Elapsed: 00:00:00.00
sys@ORCL 2023-03-13 21:14:00> col PLAN for a45;
sys@ORCL 2023-03-13 21:14:16> r
1* select plan_id,plan,status from dba_cdb_rsrc_plans
PLAN_ID PLAN STATUS
---------- --------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
19003 DEFAULT_CDB_PLAN
19004 DEFAULT_MAINTENANCE_PLAN
74965 CDB_PLAN
19006 ORA$QOS_CDB_PLAN
19005 ORA$INTERNAL_CDB_PLAN3.Oracle12c PDB的资源管理
