Tuesday, May 10, 2011

tracing an session in oracle database

tracing an session in oracle database
=====================================


dbms_system.set_sql_trace_in_session(
sid NUMBER,
serial# NUMBER,
sql_trace BOOLEAN);


exec dbms_system.set_sql_trace_in_session(2210, 1012, TRUE);

exec dbms_system.set_sql_trace_in_session(2210, 1012, FALSE);

No comments: