DBA Trace File Contents

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics, R12 only
Repository
GitHub
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.

SQL 8 lines

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

Parameters 1

ParameterTypeList of values SQL
Trace FilenameLOV
vdtfc.trace_filename=:trace_filename