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)