Saturday, January 22, 2011

Show a users current sql

Show a users current sql

Select sql_text
from   v$sqlarea
where  (address, hash_value) in
(select sql_address, sql_hash_value 
        from v$session
        where username like '&username')
/

No comments:

Post a Comment