Trace file的命名规则和存放路径

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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30126024/viewspace-2151510/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30126024/viewspace-2151510/