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博客 ” ,链接:http://blog.itpub.net/807718/viewspace-2145524/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/807718/viewspace-2145524/