How to list the all the trace events enabled in the oracle database

Question

please suggest the sql query to list the all active trace events in the oracle database. More ora trace log files are getting generated for the particular database . This might be the cause of trace was enabled for some objects or sessions or sql and missed to disable it.

Thanks, Sasikumar.

Is this related to E Biz Suite ? – Sudipta Mondal Apr 26 '17 at 09:14 — Sudipta Mondal, Apr 26 '17 at 09:14
No.. it's normal oracle 11g database.. – sasikumar Apr 26 '17 at 13:37 — sasikumar, Apr 26 '17 at 13:37

score 0 · Answer 1 · answered Jul 16 '20 at 13:51

0

Try the below.

SQL> oradebug eventdump session

answered Jul 16 '20 at 13:51

Suresh Dooly

47
2
7

How to list the all the trace events enabled in the oracle database

1 Answers1