I’ve introduced a new mode called “Paranoid” mode to the dbalarm script (which is used to monitor the Oracle database and listener logs along with monitoring locks, Space, and other events). When the paranoid mode gets enabled, the script will monitor the following additional activities/events on the Oracle database:
– EXPORT/IMPORT activities whenever they start.
– ALTER SYSTEM commands.
– ALTER DATABASE commands.
– Instance STARTUP/SHUTDOWN events.
– Other Major DB activities.
This mode is disabled by default to let the notifications focused on reporting errors. In order to enable this mode, you have to set PARANOIDMODE parameter from N to Y:
# #########################
# THRESHOLDS:
# #########################
# Modify the THRESHOLDS to the value you prefer:
…
PARANOIDMODE=Y # Paranoid mode will report more events like export/import, instance shutdown/startup. [Default Disabled]
To download and read the full list of features of dbalarm script, please visit:
http://dba-tips.blogspot.ae/2014/02/database-monitoring-script-for-ora-and.html