Parameter - TRACEFILE_IDENTIFIER

This parameter enables a user-defined suffix to be appended to the SQL trace file name.

Version Type Default Session
Modifiable		 System
Modifiable
8.1.7 String Yes No
9.0.1 String Yes No
9.2.0 String Yes No
10.1.0 String Yes No
10.2.0 String Yes No

This parameter was introduced in Oracle 8.1.7

In Oracle 9.2. trace files have the format: 

sid_ora_pid.doc

The TRACEFILE_IDENTIFER parameter optionally appends a traceid e.g. 

sid_ora_pid_traceid.doc

For example if the current trace file is: 

nt92001_ora_1760.trc

and then the parameter is set as follows: 

ALTER SESSION SET TRACEFILE_IDENTIFIER = 'TEST';

Then any subsequent trace file output will be written the following file until either the parameter is modified again or the session ends: 

nt92001_ora_1760_test.trc

This parameter is only applicable to foreground processes.

The tracefile identifier can also be set using ORADEBUG. For example to set the tracefile identifier to TEST use: 

ORADEDUG SETTRACEFILEID TEST