The value of the column time corresponds to microseconds since 2001-01-01.
select
to_char(from_tz(timestamp '2000-01-01 00:00:00' + numToDSInterval(xtr.time/1e6, 'second'),'utc' ) at local, 'yyyy-mm-dd hh24:mi:ss') tm,
xtr.component,
xtr.event,
xtr.function,
xtr.data,
xtr.sid,
xtr.serial#,
xtr.file_loc,
xtr.operation,
xtr.section,
xtr.dump,
xtr.pid,
xtr.seq#
from
x$trace xtr
-- where
-- xtr.operation is not null or
-- xtr.section is not null or
-- xtr.dump is not null
order by
xtr.time desc;
The values in the columns filename and function allow for some speculations about Oracle's internals.
Component names and event numbers
The following query finds component names and associated event numbers in x$trace:
select
case when nvl(lag(component ) over (order by lower(component), event, function), 'n/a') <> component then component end component_,
case when nvl(lag(component || event) over (order by lower(component), event, function), 'n/a') <> component || event then event end event_ ,
function
-- count(*) cnt,
-- min(data) min_data,
-- max(data) max_data
from
x$trace
group by
component,
event,
function
order by
lower(component);