Get sql text by Session ID
SELECT 
    sql_text
FROM
    v$sqltext st
WHERE
    st.hash_value = ( SELECT sql_hash_value FROM v$session s WHERE s.sid = '&sid')
ORDER BY piece ASC
/
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License