top of page
Shareware software
Working with a window

Switch "Type filter"
-
Full data - load all data from "v$diag_alert_ext"
-
Ora only - select only lines containing error text
-
Select the last - select the last N (the value is specified in the field "The number of lines (last)") lines
-
Date between - select data for a time interval
select component_id,
host_address,
originating_timestamp,
message_text
from v$diag_alert_ext
where component_id not like '%tnslsnr%'
order by originating_timestamp
bottom of page