Dev Corner

Find SQL Executed by a Session – Oracle

The following SQL shows the SQL text for the SQL being executed by a session.

SELECT s.sid,
       q.sql_text
  FROM v$sqltext q
       JOIN v$session s ON q.address = s.sql_address
 WHERE s.sid = &sid
 ORDER BY piece;

You must be logged in to post a comment.