Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The GV$OB_PLAN_CACHE_PLAN_EXPLAIN view displays the physical execution plans cached in the plan caches on all OBServer nodes.
Note
This view supports only GET operations. To query information in this view, you must specify the SVR_IP, SVR_PORT, TENANT_ID, and PLAN_ID fields.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node. |
| PLAN_ID | NUMBER(38) | NO | The ID of the plan. |
| PLAN_DEPTH | NUMBER(38) | NO | The display depth of the operator. |
| 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 in the result. |
| COST | NUMBER(38) | NO | The estimated cost. |
| PROPERTY | VARCHAR2(4096) | NO | The information about the corresponding operator. |
Sample query
obclient [SYS]> SELECT * FROM SYS.GV$OB_PLAN_CACHE_PLAN_EXPLAIN;