In today’s article, we will be learning how to customize the name of the trace file to be created for a session.
1. We determine the name to be given and we make Alter with the following command.
|
1 |
SQL> ALTER SESSION SET TRACEFILE_IDENTIFIER='OARDAHANLI'; Session altered. |
2. When we query the trace file of Session, it is seen that the special name is as follows.
|
1 2 3 4 5 |
SQL> SELECT TRACEFILE FROM V$PROCESS JOIN V$SESSION ON (ADDR=PADDR) WHERE V$SESSION.SID = SYS_CONTEXT ('USERENV', 'SID'); TRACEFILE -------------------------------------------------------------------------------- /oracle/diag/rdbms/onurdb/ONURDB/trace/ONURDB_ora_31069_OARDAHANLI.trc |
Or;
|
1 2 3 |
[root@mhrstestdb1 ~]# updatedb [root@mhrstestdb1 ~]# locate "_TEST_PID.trc" /u01/app/oracle/diag/rdbms/mhrstestdb/MHRSTEST1/trace/MHRSTEST1_ora_162225_TEST_PID.trc |
