Skip Headers
This view contains the text of SQL statements belonging to shared SQL cursors in the SGA.
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
COMMAND_TYPE
Code for the type of SQL statement (SELECT, INSERT, and so on)
SELECT
INSERT
PIECE
Number used to order the pieces of SQL text
SQL_TEXT
VARCHAR2(64)
A column containing one piece of the SQL text