Purpose
GV$OPEN_CURSOR displays the execution plans that are cached in the plan cache.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| SADDR | VARCHAR2(8) | NO | The address of the session. |
| SID | NUMBER(38) | NO | The ID of the session. |
| USER_NAME | VARCHAR2(30) | NO | The username. |
| ADDRESS | VARCHAR2(8) | NO | The SQL address. It identifies a unique SQL statement together with the Hash value of the SQL statement. The current value is NULL. |
| HASH_VALUE | NUMBER(38) | NO | The Hash value of the SQL statement. |
| SQL_ID | VARCHAR2(32) | NO | The ID of the SQL statement. |
| SQL_TEXT | VARCHAR2(60) | NO | The first 60 characters in the text of the SQL statement. |
| LAST_SQL_ACTIVE_TIME | DATE | NO | The date on which the SQL plan was last executed. |
| SQL_EXEC_ID | NUMBER(38) | NO | If an SQL plan is being executed, the corresponding SQL ID is displayed. |