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

No Comments »