Monday, May 24, 2010

Check SQL Text via User

col sql_text format a80 word_wrapped

select sql_text
from v$sqltext
where address = (select sql_address from v$session where sid=&&sid)
and hash_value = (select sql_hash_value from v$session where sid=&&sid)
order by piece

/


undefine sid

No comments: