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
Monday, May 24, 2010
Check SQL Text via User
Posted by
Jabra
at
3:59 PM
Labels: Performance Tuning
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment