Dynamic Performance (V$) Views, 157 of 179

V$SQLTEXT

This view contains the text of SQL statements belonging to shared SQL cursors in the SGA.

Column	Datatype	Description
`ADDRESS`	`RAW`	Used with HASH_VALUE to identify uniquely a cached cursor
`HASH_VALUE`	`NUMBER`	Used with ADDRESS to identify uniquely a cached cursor
`PIECE`	`NUMBER`	Number used to order the pieces of SQL text
`SQL_TEXT`	`VARCHAR2`	A column containing one piece of the SQL text
`COMMAND_TYPE`	`NUMBER`	Code for the type of SQL statement (SELECT, INSERT, etc.)