Trace file的命名規(guī)則和存放路徑是什么

Trace file的命名規(guī)則和存放路徑是什么，針對這個問題，這篇文章詳細介紹了相對應(yīng)的分析和解答，希望可以幫助更多想解決這個問題的小伙伴找到更簡單易行的方法。

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.
跟蹤文件名是平臺相關(guān)的。通常，數(shù)據(jù)庫后臺進程跟蹤文件名稱包含Oracle SID、后臺進程名稱和操作系統(tǒng)進程編號，而服務(wù)器進程跟蹤文件名包含Oracle SID、字符串“ora”和操作系統(tǒng)進程號。文件擴展名是.trc。服務(wù)器進程跟蹤文件名的一個示例是orcl_ora_344.trc。跟蹤文件有時會附帶相應(yīng)的跟蹤映射(.trm)文件，其中包含有關(guān)跟蹤文件的結(jié)構(gòu)信息，并用于搜索和導(dǎo)航。

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參數(shù)指定的目錄就是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;

關(guān)于Trace file的命名規(guī)則和存放路徑是什么問題的解答就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，如果你還有很多疑惑沒有解開，可以關(guān)注億速云行業(yè)資訊頻道了解更多相關(guān)知識。