(Sudhindra Chillarige) Everyone has a favorite script to find the active SQL statements. Here is one of mine. It builds the information using an anonymous PL/SQL block. It reads the information of active sessions from gv$session_wait and gv$session. (They have been made generic to support RAC in
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help