SQLGotcha

SQLGotcha is a tool, written in PL/SQL, to help you find sessions in an Oracle database that you want to trace. Just enter the username, machine, program, Unix PID, or even a table that is accessed. You can use SQLGotcha for both standard and event 10046 tracing, and you can make use of a unique 'waiting' mode.