top of page
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
where component_id not like '%tnslsnr%'
order by originating_timestamp
bottom of page