Purpose
V$OPEN_CURSOR displays execution plans that are cached in the plan cache.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SADDR | VARCHAR2(8) | NO | The address of the session in memory. |
| 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 value is the corresponding SQL ID. |