8.103 V$OPEN_CURSOR
V$OPEN_CURSOR
lists cursors that each user session currently has opened and parsed, or cached.
Column | Datatype | Description |
---|---|---|
|
|
Session address |
|
|
Session identifier |
|
|
User that is logged in to the session |
|
|
Used with |
|
|
Used with |
|
|
SQL identifier of the SQL statement being executed in the session |
|
|
First 60 characters of the SQL statement that is parsed into the open cursor |
|
|
Time when this cursor was last executed |
|
|
If the open cursor is executing, then the SQL execution identifier for that execution (see |
|
|
Type of cursor:
|
|
|
Address of the child cursor |
|
|
The ID of the container to which the data pertains. Possible values include:
|