ORACLE ALERT.LOG VIEWER

View syslog data alert.logDBMSOraclewithout a physical connection to the DBMS server via ssh or rdp with the ability to filter data by various parameters

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