Oracle 视图 DBA_CDB_RSRC_PLAN_DIRECTIVES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_CDB_RSRC_PLAN_DIRECTIVES是一个用于查询当前CDB的资源管理计划的视图。它显示可用的计划中的专用指令。该视图是查询，管理和监控资源计划设置的方便工具。
要使用该视图，可以执行以下查询：SELECT * FROM DBA_CDB_RSRC_PLAN_DIRECTIVES;
查询结果将显示当前CDB资源管理计划的相关信息，例如资源计划名称，实例ID，操作系统用户名，计划指令的信息，及该计划的相关状态。
官方英文解释
DBA_CDB_RSRC_PLAN_DIRECTIVES provides information about all the CDB resource plan directives.
Note:
ORA$DEFAULT_PDB_DIRECTIVE is the default directive for PDBs. For more information about ORA$DEFAULT_PDB_DIRECTIVE, see Oracle Multitenant
Administrator’s Guide.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the CDB resource plan to which this directive belongs |
|
|
|
|
Name of the PDB referred to. NULL for profile directives |
|
|
|
|
For internal use only |
|
|
|
|
For internal use only |
|
|
|
|
Resource allocation, expressed in shares |
|
|
|
|
Maximum resource utilization allowed, expressed in percentage |
|
|
|
|
Maximum percentage of the parallel target used before queueing subsequent parallel queries |
|
|
|
|
The percentage of Exadata Smart Flash Cache and Exadata PMEM cache that is guaranteed to the PDB This percentage is based on the total amount of space allocated to the CDB for Exadata Smart Flash Cache and Exadata PMEM cache. See Oracle Exadata System Software User’s Guide for more information. |
|
|
|
|
The maximum percentage of Exadata Smart Flash Cache and Exadata PMEM cache that the PDB can use This percentage is based on the total amount of space allocated to the CDB for Exadata Smart Flash Cache and Exadata PMEM cache. See Oracle Exadata System Software User’s Guide for more information. |
|
|
|
|
Text comment on the resource plan directive |
|
|
|
|
|
|
|
|
|
Whether the resource plan directive is mandatory. Mandatory plans cannot be deleted. |
Note:
Oracle recommends that you do not use the parallel_server_limit directive in a CDB resource plan.
