SELECT
 sid,
 SQL_TEXT,
 piece
FROM
 v$session se,
 sys.v_$sqltext sq
WHERE
 se.sql_address = sq.ADDRESS (+) AND
 se.SQL_HASH_VALUE = sq.HASH_VALUE (+) AND
 sid = 204
ORDER BY
 address,
 hash_value,
 piece