Active sql

[Ramon E. Estevez]

Hi gurus,   Is there any way to know which SQL statement or procedure or package is running actually.   I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA.   What I want to know is who is actually running something in the DB.   TIA     Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121