Trace file names are platform-dependent. Typically, database background process trace file names contain the Oracle SID, the background process name, and the operating system process number, while server process trace file names contain the Oracle SID, the string "ora", and the operating system process number. The file extension is .trc. An example of a server process trace file name is orcl_ora_344.trc. Trace files are sometimes accompanied by corresponding trace map (.trm) files, which contain structural information about trace files and are used for searching and navigation.
跟蹤檔名是平臺相關的。通常，資料庫後臺程式跟蹤檔名稱包含Oracle SID、後臺程式名稱和作業系統程式編號，而伺服器程式跟蹤檔名包含Oracle SID、字串“ora”和作業系統程式號。副檔名是.trc。伺服器程式跟蹤檔名的一個示例是orcl_ora_344.trc。跟蹤檔案有時會附帶相應的跟蹤對映(.trm)檔案，其中包含有關跟蹤檔案的結構資訊，並用於搜尋和導航。

Trace file的存放路徑
SQL> show parameter user_dump_dest
USER_DUMP_DEST specifies the pathname for a directory where the server will write debugging trace files on behalf of a user process.
--user_dump_dest引數指定的目錄就是trace file的目錄

To find the trace file for your current session:
SQL>SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Default Trace File';

To find all trace files for the current instance:
SQL>SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

To determine the trace file for each Oracle Database process:
SQL>SELECT SPID,PROGRAM,TRACEFILE FROM V$PROCESS;

Trace file的命名規則和存放路徑

相關文章