CODEWITHSUNDEEP
oracle-database
cagcowboy
cagcowboy

Reputation: 30848

How can I tell which sessions are tracing (after a call to DBMS_MONITOR.SESSION_TRACE_ENABLE)

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)

Upvotes: 2

Views: 807

Answers (1)

dpbradley
dpbradley

Reputation: 11915

The dynamic V$SESSION view has this info:

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

Upvotes: 3

Related Questions