One
should implement a monitoring system to constantly monitor the following
aspects of a database.
Writing custom scripts, implementing Oracle's Enterprise Manager or buying a third party monitoring product that can achieve this. If an alarm is triggered, system should automatically notify the DBA (e – mail, pager etc.) to take appropriate action.
Writing custom scripts, implementing Oracle's Enterprise Manager or buying a third party monitoring product that can achieve this. If an alarm is triggered, system should automatically notify the DBA (e – mail, pager etc.) to take appropriate action.
Infrastructure availability
- Is the database up and responding to request
- Are the listeners up and responding to request
- Are Oracle Names and LDAP Servers up and responding to request
- Are the Web Listeners up and responding to requests
- Is the archive log destination filling up?
- Objects getting close to their max extents
- User and process limits reached