To check 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')
Friday, July 11, 2008
Subscribe to:
Post Comments (Atom)
Basic Oracle database Commands and Usages
No comments:
Post a Comment