
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
select component_id,
host_address,
originating_timestamp,
message_text
from v$diag_alert_ext
where component_id not like '%tnslsnr%'
order by originating_timestamp