»
S
I
D
E
B
A
R
«
tracking current sql of sid on oracle
November 13th, 2009 by sayo


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

Leave a Reply

»  Substance: WordPress   »  Style: Ahren Ahimsa