ORACLE ALERT.LOG VIEWER
Viewing System Log Data alert.log Oracle DBMS without a physical connection to the DBMS server via ssh or rdp with the ability to filter data by various parameters
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 indicated in the field "The number of lines (last)"
date between - select data for a time interval
where component_id not like '%tnslsnr%'
order by originating_timestamp