Apps DBA Concepts

Just another WordPress.com weblog

Find the current SQL in the database

Posted by vasselva on July 16, 2008

select username, sql_text from v$session s, v$sqlarea sql where s.sql_address = sql.address and s.sql_hash_value = sql.hash_value;

Leave a comment