oraclespin.com
How to find SQL running for a user/sid?
Using the SQL below in which joining with V$session and V$sqlarea one can find the SQL currently running. In this example using a session id one can find the SQL running SQL> select a.sid, a.ser…