Logo

Home / Monitoring

Monitoring

Database Daily Check

Database Weekly Check

Database Daily Check

Our monitoring tool executes several different checks on the database which need to run at least once a day (depending on the nature of the actual check) given that they examine critical aspects of the database environment.

This process generates an HTML report that provides information about the status and health of the database in 22 fundamental checks. This report is essential to assist the DBA in understanding the current status of the database and in spotting issues (or potential issues) that need to be fixed on any of the components being addressed in the report.

This process involves the following areas/components:

  • Status review of:Database, Listener, Datafiles, DB Components, Archiving Destinations.
  • Hit Ratios review: Buffer Cache, PGA Cache, Library Cache, Sort.
  • Free space locations review.
  • Extents review: Next-extents, Max-extents.
  • Invalid indexes check, invalid objects check, jobs check.
  • Database locked and expired users.
  • Shadow Processes.
  • Extents review: Next-extents, Max-extents.
  • Log errors check.
  • Etc.

Database Online Check

This process executes in a very short period of time (every 10 minutes) and it checks the “vital signs” of the database environment, generating critical alerts for the DBA so he can take immediate action to correct the problem. This check has been designed to execute consuming a very low amount of resources at database level so its execution is very fast and it does not impact the system performance in any way.

Backup Check

This program checks if a consistent and usable backup that allows the DBA to recover the database taken in the past 24 hours exists. Such a process is extremely useful for the company to make sure the backup routine has worked as expected.

TOP CPU check

This program detects database processes that are executing and consuming a high amount of server resources (configurable). This program is very effective to detect and immediately report these processes (runaway processes) that might be severely impacting the system performance so that the DBA can take proper action.

Locked sessions check

This program detects blocking scenarios in which one or several sessions are being “blocked” by resources being locked by other session/s. Right after the blocking scenario has been identified, the program generates an alert (in HTML format) which contains detailed information about the session responsible for this blocking condition (session id, SQL sentence being executed, etc.) as well as information on all the sessions that are currently waiting. This information is sent to the DBA so the corrective action to resolve the problem can be immediately taken.

The program also has the ability to automatically “release” the blocking scenario.

Database Weekly Check

Our monitoring tool executes several different checks on the database on a weekly basis to ensure that the database is working as it should. Our goal is to detect possible issues before they become a critical situation or to address them ASAP if they have already become a serious problem. In this direction, we developed a set of automated processes that cover different areas of interest for each component implemented in the environment.

Block Corruption Check

This process checks for corrupted blocks at the database notifying the DBA in case immediate action would be required.

Purging of trace and log files

This process purges old trace files stored at the bdump, udump, cdump directories plus the alert log file and listener log file. Regarding these last two last log files, it can be defined not to purge them and instead create backups in order to avoid having significant big alert and listener log files.

Database segment reorganization check

This program performs an analysis of all database indexes and tables detecting which segments must be re-organized (re-created) to reduce their sizes and increase their efficiency. Additionally this process would automatically generate the SQL sentences that will need to be used to execute this activity.

Database Growth Analysis

This program collects the required information and generates a database growth report containing detailed information about segment type and tablespace growth at daily, weekly and monthly level. Such information is very important for capacity planning activities.