ITPub博客

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

原创 Oracle 作者:lusklusklusk 时间:2018-03-05 14:18:43 0 删除 编辑
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;
请登录后发表评论 登录
全部评论
Welcome to Lukes ORALC HOME,11G OCM认证,5年以上DBA工作经验,两年运维团队管理经验,本博客仅记录自己的一个学习过程,不保证完全准确,如有需要,欢迎转载。

注册时间:2015-02-02

  • 博文量
    320
  • 访问量
    276166