Oracle Database Administration
Database Tips
Thursday, October 25, 2007
Find out last sql statement issued from the same session
select sql_text from v$sql
where hash_value = ( select prev_hash_value from v$session
where sid = (select sid from v$mystat where rownum = 1))
/
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment