Session Tracing
Enable Session Tracing
--
-- Enable Session Tracing
--
EXEC DBMS_MONITOR.SESSION_TRACE_ENABLE(&sid,&serial);
Disable Session Tracing
--
-- Disable Session Tracing
--
EXEC DBMS_MONITOR.SESSION_TRACE_DISABLE(&sid,&serial);
Check if Session Tracing is On
--
-- Check if Session Tracing is On
--
set lines 180
col module for a45
col sql_trace_waits for a20
col sql_trace_binds for a20
col sql_trace for a20
select username,module,sid,sql_trace,sql_trace_waits,sql_trace_binds from v$session where sql_trace='ENABLED'
/
