Note
This view is available starting with V4.0.0.
Overview
The V$OB_PLAN_CACHE_PLAN_EXPLAIN view displays the physical execution plans cached in the plan cache of the current OBServer node.
Note
This view supports only the GET operation. When querying, you must specify the TENANT_ID and PLAN_ID fields.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | Tenant ID |
| SVR_IP | VARCHAR2(46) | NO | Server IP Address |
| SVR_PORT | NUMBER(38) | NO | Server Port Number |
| PLAN_ID | NUMBER(38) | NO | Plan ID |
| PLAN_DEPTH | NUMBER(38) | NO | Depth of Operator Display |
| PLAN_LINE_ID | NUMBER(38) | NO | Operator ID |
| OPERATOR | VARCHAR2(128) | NO | Operator name |
| NAME | VARCHAR2(256) | NO | Table name |
| ROWS | NUMBER(38) | NO | Estimated Number of Result Lines |
| COST | NUMBER(38) | NO | Estimated Cost |
| PROPERTY | VARCHAR2(4096) | NO | Information of the corresponding operator |
Sample query
Query cache refers to the physical execution plans stored in the plan cache of the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$OB_PLAN_CACHE_PLAN_EXPLAIN WHERE ROWNUM <= 1;
The query result is as follows:
+-----------+----------------+----------+---------+------------+--------------+-----------+------+------+------+----------+
| TENANT_ID | SVR_IP | SVR_PORT | PLAN_ID | PLAN_DEPTH | PLAN_LINE_ID | OPERATOR | NAME | ROWS | COST | PROPERTY |
+-----------+----------------+----------+---------+------------+--------------+-----------+------+------+------+----------+
| 1004 | xx.xx.xx.xx | 2882 | 2012 | 0 | 0 | PHY_LIMIT | NULL | 1 | 105 | NULL |
+-----------+----------------+----------+---------+------------+--------------+-----------+------+------+------+----------+
1 row in set (0.008 sec)