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