Note
This view is available starting with V4.0.0.
Purpose
The GV$OB_PLAN_CACHE_PLAN_EXPLAIN view displays the physical execution plans cached in all OBServer nodes.
Note
This view supports only GET operations. When you query this view, you must specify the IP, PORT, TENANT_ID, and PLAN_ID columns.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| PLAN_ID | NUMBER(38) | NO | The ID of the plan. |
| PLAN_DEPTH | NUMBER(38) | NO | The depth of the operator when it is displayed. |
| PLAN_LINE_ID | NUMBER(38) | NO | The ID of the operator. |
| OPERATOR | VARCHAR2(128) | NO | The name of the operator. |
| NAME | VARCHAR2(256) | NO | The name of the table. |
| ROWS | NUMBER(38) | NO | The estimated number of rows. |
| COST | NUMBER(38) | NO | The estimated cost. |
| PROPERTY | VARCHAR2(4096) | NO | The information about the operator. |
Sample query
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)