V$SQLTEXT displays the text of SQL statements belonging to shared SQL cursors in the SGA.
| Column | Datatype | Description |
|---|---|---|
ADDRESS |
RAW(4 | 8) |
Used with HASH_VALUE to uniquely identify a cached cursor |
HASH_VALUE |
NUMBER |
Used with ADDRESS to uniquely identify a cached cursor |
SQL_ID |
VARCHAR2(13) |
SQL identifier of a cached cursor |
COMMAND_TYPE |
NUMBER |
Code for the type of SQL statement (SELECT, INSERT, and so on) |
PIECE |
NUMBER |
Number used to order the pieces of SQL text |
SQL_TEXT |
VARCHAR2(64) |
A column containing one piece of the SQL text |