select
adr_home || '/' || trace_filename trace_file_name,
timestamp,
line_number,
payload txt,
file_name c_source_file,
function_name c_function,
component_name,
record_type
from
x$dbgtfview
where
-- session_id = 156 and
-- serial# = 38124 and
1 =1
order by
-- session_id,
-- serial#,
line_number
;