Just wanted to share this small thingy. When you are setting up your DB Trace for DB gurus to read (I found in Oracle only real DB sorcerers can decode this) you might make your life easier a bit, if in addition to well known:
"ALTER SESSION SET EVENTS '10046 trace name context forever, level 12'"; – for switching on
"ALTER SESSION SET EVENTS '10046 trace name context off'"; – for switching off
you add “ALTER SESSION SET tracefile_identifier” to give a name to a trace file and relate it to your activity in this way.
Whole code would look like:
This would give you file name like: xyz_ora_1142900_40a2e9ef_be21_4a0c_9a5e_aa70dfb8e423, that is quite better traceable back into your activity.
[14-Apr-2011] Small update, here is how the db trace setup looks in the pl-sql itself if you ever need it: