Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 |
