oradebugTrace.txt
04-02-2002 Bikle
---------------------

Some info I got here:
http://www.dbspecialists.com/presentations/wait_events.html
on tracing activity in another session.

Look in v$session and v$process to find the Oracle PID

Once I find it, supply it to an oracle oradebug session:

sql> oradebug setorapid 22
sql> oradebug session_event 10046 trace name context forever, level 8

Another way to do it:

Look in v$session to find sid, and serial#.

Then use these:

sys.dbms_system.set_sql_trace_in_session (sid, serial#, TRUE);
sys.dbms_system.set_ev ...

Eventually (or very quickly) interesting information will appear in a
user_dump_dest .trc file.