Use oradebug in sqlplus to locate the trace file generated by the alter session 10046 event

[root@HXZG ~] # su-oracle [oracle@HXZG ~] $sqlplus / as sysdbaSQL > select * from v$versionBANNER-Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0-ProductionNLSRTL Version 11.2.0.3.0-Production now generates a 10046 event Let's look at the trace file SQL > alter session set events' 10046 trace name context forever, level 12' Session altered.SQL > oradebug setmypidStatement processed.SQL > oradebug tracefile_name/u01/app/oracle/diag/rdbms/hxzgsjqy/HXZGSJQY/trace/HXZGSJQY_ora_15039.trcoradebug to locate the trace file generated by the 10046 event is HXZGSJQY_ora_15039 [oracle@HXZG ~] $cd / u01/app/oracle/diag/rdbms/hxzgsjqy/HXZGSJQY/trace/ [oracle@HXZG trace] $lltotal 100 RWMI r-1 oracle oinstall 2458 Nov 16 02:00 alert_HXZGSJQY.log-rw-r--r- -1 oracle oinstall 0 Nov 16 21:31 cd-rw-r- 1 oracle oinstall 1012 Nov 16 02:00 HXZGSJQY_cjq0_6039.trc-rw-r- 1 oracle oinstall 63 Nov 16 02:00 HXZGSJQY_cjq0_6039.trm-rw-r- 1 oracle oinstall 21287 Nov 16 02:00 HXZGSJQY_dbrm_5983.trc-rw-r- 1 oracle oinstall 1387 Nov 16 02:00 HXZGSJQY_dbrm_5983.trm-rw-r-- -1 oracle oinstall 953 Nov 16 19:00 HXZGSJQY_j000_14503.trc-rw-r- 1 oracle oinstall 73 Nov 16 19:00 HXZGSJQY_j000_14503.trm-rw-r- 1 oracle oinstall 32035 Nov 16 21:31 HXZGSJQY_mmon_5999.trc-rw-r- 1 oracle oinstall 3136 Nov 16 21:31 HXZGSJQY_mmon_5999.trm-rw-r- 1 oracle oinstall 2428 Nov 16 21:31 HXZGSJQY_ora_15039 Trc-rw-r- 1 oracle oinstall 121 Nov 16 21:31 HXZGSJQY_ora_15039.trm-rw-r- 1 oracle oinstall 1267 Nov 16 02:13 HXZGSJQY_ora_9981.trc-rw-r- 1 oracle oinstall 85 Nov 16 02:13 HXZGSJQY_ora_9981.trm