The following activities are monitored on a Database :
Task/Machine
Schedule
Description
Connect to Database Hourly To monitor the availability of database server and Oracle listener.
Check Alert Logs Hourly To check the alert log file periodically to identify any logs for errors / warnings. It will automatically send an SMS to the administrator.
Check Tablespace Size Hourly To check the size of free tablespace and free space available. If the tablespace reaches the threshold limit, it will automatically send an SMS message to the administrator.
Verify Rollback Segments Shift To check the status of the rollback segments.
Verify if any resources locked Shift To identify any locked resources.
Verify Archive Logs Daily To check if the archive logs are created properly in the current directory and if standby configuration is enabled, check whether the archive logs are backed, transferred and applied properly.
Hit Ratio Daily To check the overall buffer cache hit ratio for the entire instance since it was started. If the ratio reaches the threshold limit, it will automatically send an SMS message to the administrator.
Check Listener Log File Size Daily To check the size of listener log files on each database instance. If the listener log file size reaches the threshold limit, notification will be sent to the administrator.
Size of Extents Daily To check the segments of each table space, number of extents, initial size of extent, next extent size, minimum extents, maximum extent and status.
Check Disk Space Daily To check the disk space availability for data files, log files and temp space. If the available size reaches the threshold limit, it will automatically send an SMS message to the administrator.
Check CPU Usage Daily Monitors the CPU performance and its usage.
Check Memory Usage Daily Monitors the memory usage, memory page faults, etc.
Check System Log Files Daily To check the Event Viewersystem log files. To see and watch for any OS related warnings or errors.
Check for Invalid Objects Weekly To identify invalid objects in the database.
Check for Chained Rows Weekly To identify chained rows and manag
Oracle Database shall be monitored using The Capacity Planner and Performance Manager applications, This includes special Performance Manager diagnostics such as Performance Overview, TopSessions, TopSQL and Lock Monitor .
Administrators will be able to investigate an event directly from the console’s event viewer through direct access to Performance Manager charts, diagnostic help and historical data related to metrics being monitored by the event.
This provides a logical step-by-step methodology for discovering and investigating performance problems.
In addition, events and Performance Manager charts can share common metric thresholds, allowing consistent performance thresholds to be used by administrators whether monitoring in lights-out mode or real time. With 9i, events can also be registered directly from Performance Manager charts.
Task/Machine
Schedule
Description
Connect to Database Hourly To monitor the availability of database server and Oracle listener.
Check Alert Logs Hourly To check the alert log file periodically to identify any logs for errors / warnings. It will automatically send an SMS to the administrator.
Check Tablespace Size Hourly To check the size of free tablespace and free space available. If the tablespace reaches the threshold limit, it will automatically send an SMS message to the administrator.
Verify Rollback Segments Shift To check the status of the rollback segments.
Verify if any resources locked Shift To identify any locked resources.
Verify Archive Logs Daily To check if the archive logs are created properly in the current directory and if standby configuration is enabled, check whether the archive logs are backed, transferred and applied properly.
Hit Ratio Daily To check the overall buffer cache hit ratio for the entire instance since it was started. If the ratio reaches the threshold limit, it will automatically send an SMS message to the administrator.
Check Listener Log File Size Daily To check the size of listener log files on each database instance. If the listener log file size reaches the threshold limit, notification will be sent to the administrator.
Size of Extents Daily To check the segments of each table space, number of extents, initial size of extent, next extent size, minimum extents, maximum extent and status.
Check Disk Space Daily To check the disk space availability for data files, log files and temp space. If the available size reaches the threshold limit, it will automatically send an SMS message to the administrator.
Check CPU Usage Daily Monitors the CPU performance and its usage.
Check Memory Usage Daily Monitors the memory usage, memory page faults, etc.
Check System Log Files Daily To check the Event Viewersystem log files. To see and watch for any OS related warnings or errors.
Check for Invalid Objects Weekly To identify invalid objects in the database.
Check for Chained Rows Weekly To identify chained rows and manag
Oracle Database shall be monitored using The Capacity Planner and Performance Manager applications, This includes special Performance Manager diagnostics such as Performance Overview, TopSessions, TopSQL and Lock Monitor .
Administrators will be able to investigate an event directly from the console’s event viewer through direct access to Performance Manager charts, diagnostic help and historical data related to metrics being monitored by the event.
This provides a logical step-by-step methodology for discovering and investigating performance problems.
In addition, events and Performance Manager charts can share common metric thresholds, allowing consistent performance thresholds to be used by administrators whether monitoring in lights-out mode or real time. With 9i, events can also be registered directly from Performance Manager charts.
Hi Vinod,
ReplyDeleteHow I can setup SMS alerting for oracle database alert in HPUX server.
Thnaks in advance,
Soumik