Oracle-EBS-SQL/DBA Trace File Contents/DBA Trace File Contents.sql at master · Enginatics/Oracle-EBS-SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
/*************************************************************************/
/*                                                                       */
/*                       (c) 2010-2024 Enginatics GmbH                   */
/*                              www.enginatics.com                       */
/*                                                                       */
/*************************************************************************/
-- Report Name: DBA Trace File Contents
-- Description: V$DIAG_TRACE_FILE_CONTENTS contains trace data that is present in the trace files that are part of the current Automatic Diagnostic Repository (ADR).
Supported starting from Oracle Database 12.2.
-- Excel Examle Output: https://www.enginatics.com/example/dba-trace-file-contents/
-- Library Link: https://www.enginatics.com/reports/dba-trace-file-contents/
-- Run Report: https://demo.enginatics.com/

select
vdtfc.payload trace_contents
from
v$diag_trace_file_contents vdtfc
where
1=1
order by
vdtfc.line_number