Oracle open trace and analyze trace

SQL> oradebug event 10046 trace name context forever, level 8ORA-00072: process "Unix process pid: 1564906, image: oracle @ db02 (P007)" is not activeSQL> oradebug setospid 2703564 Oracle pid: 452, Unix process pid: 2703564, image: oracle @ db02SQL> oradebug event 10046 trace name context forever, level 8 Statement processed. SQL> oradebug tracefile_name/u01/PRODDB/admin/diag/rdbms/prod/PROD2/trace/PROD2_ora_2703564.trcSQL> oradebug event 10046 trace name context forever, level 12 Statement processed.

1. Open the 10046 event

2. Tracking session events

3. Find the file name.

4. Close the event.

Oradebug event 10046 trace name context off;