Топ-100
 
CerebroSQL

ORACLE ALERT.LOG VIEWER

The window allows you to view the system log data  alert.log of Oracle DBMS.

View database alert.log.jpg

-> Request to retrieve data <-

select component_id, host_address, originating_timestamp, message_text
  from v$diag_alert_ext
  where component_id not like '%tnslsnr%'
order by originating_timestamp

-----

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)") lines

  • Date between  - select data for a time interval