DBA Daily Activity

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.