1）V$DIAG_TRACE_FILE V$DIAG_TRACE_FILE_CONTENTS
在12.2中，Oracle新增了两个V$DIAG_TRACE_FILE and V$DIAG_TRACE_FILE_CONTENTS视图，使查看trace文件路径及其内容变得非常简单。不用大把拼接sql去查了。

---查看con_id为3的产生的trace文件路径及名称

SELECT ADR_HOME,TRACE_FILENAME,CON_ID
FROM v$diag_trace_file
WHERE con_id = 3;
ADR_HOME TRACE_FILENAME CON_ID
-------------------------------------- ------------------------ ----------
/u01/app/oracle/diag/rdbms/orcl/orcl orcl_mmon_2309.trc 3
...

---查看对应trace文件内容

SELECT payload
FROM v$diag_trace_file_contents
WHERE trace_filename = 'orcl_mmon_2309.trc'
ORDER BY line_number;

2)

3)

4)

5)

ITPub博客

oracle 12c 有用的系统视图

最新文章