Latest Updates

Post Top Ad

10 July, 2013

To find the sql query for a given concurrent request sid?

select sid,sql_text from gv$session ses, gv$sqlarea sql where
ses.sql_hash_value = sql.hash_value(+) and ses.sql_address = sql.address(+) and ses.sid='&oracle_sid'
/

No comments:

Post Top Ad

Your Ad Spot

Pages