Note
This view is available starting with V4.0.0.
Overview
The GV$OB_PLAN_CACHE_PLAN_EXPLAIN view displays the physical execution plans cached in the plan cache on all OBServer nodes.
Note
This view supports only the GET operation. When querying, you must specify the IP, PORT, 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 cached in the plan cache on all OBServer nodes.
obclient [SYS]> SELECT * FROM SYS.GV$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 | 2011 | 0 | 0 | PHY_LIMIT | NULL | 1 | 105 | NULL |
+-----------+----------------+----------+---------+------------+--------------+-----------+------+------+------+----------+
1 row in set (0.016 sec)