tags:

views:

22

answers:

1

Is there a data-dictionary view or some other way of telling which (if any) sessions currently have tracing enabled (after a call to DBMS_MONITOR.SESSION_TRACE_ENABLE)?

(At the minute I keep running an ls on the udump folder, but this isn't exactly foolproof)

+1  A: 

The dynamic V$SESSION view has this info:

select * from v$session where sql_trace = 'ENABLED'

dpbradley
Bingo. Thanks.
cagcowboy