Sunday, November 11, 2007
SQL stetment of a USER
Below SQL query is used to find the SQL statement of a USER:
select sess.sid, sqltext.piece, sqltext.sql_text, sqltext.command_type
from v$sqltext sqltext, v$session sess
where sqltext.address = sess.sql_address
and sqltext.hash_value = sess.sql_hash_value
and sess.username = 'NAIKH'
order by 2;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment