Shulou(Shulou.com)05/31 Report--

What is the naming rule and storage path of Trace file? in order to solve this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a simpler and easier way.

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.

The trace file name is platform-dependent. Typically, the database background process trace file name contains Oracle SID, background process name, and operating system process number, while the server process trace file name contains Oracle SID, the string "ora", and the operating system process number. The file extension is .trc. An example of a server process tracking file name is orcl_ora_344.trc. Trace files sometimes come with a corresponding trace mapping (.trm) file, which contains structural information about the trace file and is used for search and navigation.

Storage path of 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.

-- the directory specified by the user_dump_dest parameter is the directory of 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

This is the answer to the question about the naming rules and storage path of Trace file. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.