Note
This view is available starting with V3.1.2.
Purpose
The V$RSRC_PLAN view displays the resource management plan for the current active tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| ID | NUMBER | NO | The unique ID of the resource plan. |
| NAME | VARCHAR2(128) | NO | The name of the resource plan. |
| IS_TOP_PLAN | VARCHAR2(5) | NO | Indicates whether the current resource plan is the top-level plan:
TRUE. |
| CPU_MANAGED | VARCHAR2(3) | NO | Indicates whether the CPU usage is managed by the current resource plan:
ON. |
| INSTANCE_CAGING | VARCHAR2(3) | NO | This column is for compatibility. The value is always NULL. |
| PARALLEL_SERVERS_ACTIVE | NUMBER | NO | This column is for compatibility. The value is always NULL. |
| PARALLEL_SERVERS_TOTAL | NUMBER | NO | This column is for compatibility. The value is always NULL. |
| PARALLEL_EXECUTION_MANAGED | VARCHAR2(32) | NO | This column is for compatibility. The value is always NULL. |
Sample query
Query the resource management plan of the current active tenant.
obclient [SYS]> SELECT * FROM SYS.V$RSRC_PLAN;
The query result is as follows:
+------+---------+-------------+-------------+-----------------+-------------------------+------------------------+----------------------------+
| ID | NAME | IS_TOP_PLAN | CPU_MANAGED | INSTANCE_CAGING | PARALLEL_SERVERS_ACTIVE | PARALLEL_SERVERS_TOTAL | PARALLEL_EXECUTION_MANAGED |
+------+---------+-------------+-------------+-----------------+-------------------------+------------------------+----------------------------+
| NULL | daytime | TRUE | ON | NULL | NULL | NULL | NULL |
+------+---------+-------------+-------------+-----------------+-------------------------+------------------------+----------------------------+
1 row in set