REM RMINC_whatsrunning.sql
REM
REM Copyright 2000, All Rights Reserved, Reed-Matthews, Inc.
REM
REM You enter the Oracle Sid from whosrunning.sql, and this will tell you what
REM sql statement is being run
REM
REM &SID is the SID from RMINC_whosrunning.sql:
SELECT T.SQL_TEXT FROM V$SQLTEXT T, V$SESSION S WHERE S.SID = &SID 
AND S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE;