Search notes:

Oracle: V$SQLTEXT

v$sqltext displays pieces of maximal 64 characters (bytes?) from the shared SQL cursors in the SGA.

Newlines are replaced with spaces. In order to get text pieces with new lines, v$sql_text_with_newlines must be used.

select /* tq84-tq84 */
  t.sql_text
from
  v$sqlarea  a join
  v$sqltext  t on a.sql_id = t.sql_id
 where
  a.sql_text like '%tq84-tq84%'
order by
  t.piece;

Github repository oracle-patterns, path: /Installed/dynamic-performance-views/sql/text/tq84.sql

Oracle: V$SQLTEXT

See also