The Eucharistic Miracles of the World
This parameter is used to identify the tracefile easily from the directory. When you specify or set this parameter with a value that value becomes the part of the trace file name. So that easily can be identified from the directory. This is a session modifiable parameter and each time when you modify the parameter value the name of the very immediate trace file will get effect of the same.  Trace file continuity information is automatically added to both the old and new trace files to indicate that these trace files belong to the same process.
See an example here.

SQL> alter session set TRACEFILE_IDENTIFIER ='Curr_Sess';

Session altered. 

SQL> alter session set TIMED_STATISTICS = TRUE; 

Session altered.
SQL> alter session set sql_trace=true; 

Session altered.
-rw-r----- 1 oracle oinstall      188 Mar 13 12:41 kqtst_ora_30492_Curr_Sess.trm

-rw-r----- 1 oracle oinstall     4280 Mar 13 12:41 kqtst_ora_30492_Curr_Sess.trc



Post a comment


Oracle (575) General (60) Unix (47) Blog (23) Script (12) OCI (3) SQL* Loader (3) Software (1) Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer