Ability to trace a session from the session list.
Logged In: YES
How do you do that?
Logged In: NO
Trace a session:
EXEC SYS.DBMS_SYSTEM.Set_Sql_Trace_In_Session(sid, serial#,
Trace a session with specific event/level:
EXEC SYS.DBMS_SYSTEM.Set_Ev(sid, serial#, event, level, name);
1 - Standard SQL_TRACE functionality.
4 - As level 1 plus tracing of bind variables.
8 - As level 1 plus wait events.
12 - As level 1 plus bind variables and wait events.
You can also use the Oracle Trace (otrace) facility if
serial#, true/false, collection_name, server_event_set)
See "Controlling Oracle Trace Collections from PL/SQL" from OTN:
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.