v$diag_trace_file lists all trace files that are currently present in the Automatic Diagnostic Repository (ADR) in the current container. select adr_home, trace_filename, change_time, modify_time, con_id from v$diag_trace_file order by change_time desc;