| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
This view lists cursors that each user session currently has opened and parsed.
| Column | Datatype | Description |
|---|---|---|
SADDR |
RAW(4 | 8) |
Session address |
SID |
NUMBER |
Session identifier |
USER_NAME |
VARCHAR2(30) |
User that is logged in to the session |
ADDRESS |
RAW(4 | 8) |
Used with HASH_VALUE to uniquely identify the SQL statement being executed in the session |
HASH_VALUE |
NUMBER |
Used with ADDRESS to uniquely identify the SQL statement being executed in the session |
SQL_ID |
VARCHAR2(13) |
SQL identifier of the SQL statement being executed in the session |
SQL_TEXT |
VARCHAR2(60) |
First 60 characters of the SQL statement that is parsed into the open cursor |
