Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Parameters

TRACEFILE_IDENTIFIER

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

It enables a user-defined suffix to be appended to the SQL trace file name. 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 to 
    nt92001_ora_1760_test.trc
until either the parameter is modified again or the session ends.

This parameter is only applicable to foreground processes.