V$SQLTEXT

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