check for FATAL and ERROR log messages from the system

posted Oct 9, 2014, 3:04 PM by Sachchida Ojha
Run SQL

select * from log_alert_history where logseverity in ('FATAL', 'ERROR') and logtime > (now() - interval '15 minutes');

Analyze the alert. You may want to add additional filters to the query to ignore certain messages of low interest
Comments