Oracle Database Health Check

Oracle Support

Oracle Database Health Check

Database servers are more important than ever today. Your data platform enables your business to run effectively, to provide invaluable insights and to give you competitive advantage.

Our Oracle Health Check is targeted at assessing the performance, stability and availability of your Oracle based systems. The aim is to detect and correct potential problems before they occur or develop into major defects. This analysis can be focused on performance, capacity, configuration issues or concerns. Our goal is to help your business prevent downtime and keep a known, predictable performance for your databases servers.


Making the most of your investment

Database servers are a major investment for most organisations and a significant one. Ensuring you are getting the most of that investment is key. We do this by measuring the efficiency of your database server; essentially, is the system “firing on all cylinders”?

The efficiency of a system takes into consideration issues such as:

  • Is the database and operating system properly tuned?
  • Are there sufficient hardware resources for the various applications?
  • Is your High Availability and DR working and fit for purpose?
  • Have the proper indexes been created?
  • Are critical administrative utilities run regularly?
  • Is there adequate support and documentation of the system?

In a complex computing environment, the extent to which these and other issues are addressed will affect the overall efficiency and effectiveness of the systems in place. The database Health Check addresses these issues of efficiency and effectiveness by having a skilled Oracle engineer assess your Oracle-based computing environment.


Health Check Modules

DSP have developed a set of individual modules to check the health and status of your Oracle Database. From the good practice “General Health Check” to the targeted “Performance” and “Capacity” planning checks.


Module 1: General Health

Our general health checks use a combination of leading edge Oracle monitoring tools and bespoke scripts to complete over 400 system checks including:

  1. Operating System Configuration
  2. Oracle Configuration
  3. Resource Configuration
  4. Database Configuration
  5. Backup and Maintenance
  6. General Security
  7. Service & Supportability Landscape

The general Health Check provides the foundation for the other modules… Find out more


Module 2: Performance

Performance Reviews are there for targeted problems or issues with Oracle Performance. These include:

  1. Index Performance (Missing, Duplicate, Not needed)
  2. Wait Stats & Queues
  3. Database Locks
  4. Query Performance (Top 25 Frequent, most costly)
  5. Resource Utilisation (CPU, Memory, Disk Network)… Find out more

Module 3: High Availability and Disaster Recovery

Performance Reviews are there for targeted problems or issues with Oracle Performance. These include:

  1. Backup & Restore Integrity
  2. High Availability review
  3. Recovery Time and Objective Review
  4. Fail-Over Testing
  5. Documentation Review… Find out more

Module 4: Architecture

Unsure on how many Oracles you have deployed or how well they meet your architecture guidelines? This module will give you an instant insight into:

  1. Oracle Discovery
  2. Service Landscape & Supportability
  3. Business Criticality Review
  4. Datacentre Capability
  5. Hardware Capability… Find out more

Module 5: Capacity Health Check

Capacity Planning is the process of determining what type of hardware and software configuration is required to meet application needs.

The capacity module determines what your system needs (and when it needs it) to maintain performance in both steady-state and peak usage period, whilst ensuring you’re data growth patterns are accounted for… Find out more


Our Delivery

At the end of the Health check you get a fully comprehensive report showing all of our findings. These are graded by their criticality to your Oracle Infrastructure and performance impact.

Each report clearly presents our finding to you and details:
– Criticality of the Problem
– What the problem is and why it is an issue
– Steps & Recommendations to take to resolve the Problem


Build your Own Module

Our Modules are configured to be turnkey solutions, but if these do not match your needs talk to us about a customised module.

We will be happy to pick individual health check items into a customised module.


How does it work?

Our simple targeted health check helps our customers tailor their package to specific issue (s) they wish to address.


Step 1 – Speak to us about the type of problems your experiencing

  • Application freezes during peak trading hours
  • Are you experiencing bad performance after an upgrade?
  • Exponential database growth, but you can’t understand why
  • Concerned that you’re backup and recovery options are no longer fit for purpose
  • Need to certify that your database follows best practices

Step 2 – Choose your modules

We’ll ensure the modules you choose address the problems you need fixing.

  1. Application freezes during peak trading hours (Performance module)
  2. Exponential database growth, but you can’t understand why (Capacity Module)
  3. Need to certify that your database follows best practices (General Health Check)

Step 3 – Engage and Report

We will engage to complete the Health Check, then we will present back to you with a clear comprehensive report breaking down all findings by:

  • Criticality of issue
  • Reasons why we have identified the problem
  • Steps to take to resolve the issue

Step 4 – Make Recommended Changes

This is where the rubber hits the road, improving your system. Our report will provide you the blue prints, either engage us to complete the recommendations or complete them yourself.


Step 5 – Review Improvements

DSP can provide a continuous service where we come back to review the improvements that were made and perform a refresh of the health check to measure the performance & stability improvements.


Case Study

“DSP Oracle health checks helped stabilise a Large Retail Organisation’s production systems before they entered their peak trading season”.
The Oracle health check identified potential problems related to both performance and capacity. A remedial action plan was developed and implemented by DSP principle consultants to re-organise highly fragmented objects within a number of tablespaces. This resulted in a large amount of space being made available to support future growth without incurring additional capital expenditure, whilst at the same time improving reporting and system access to information stored in the Oracle databases.

Oracle Database Support

Oracle Database Support
Oracle Database Support

Oracle Database Monitoring

Oracle Database Monitoring
Oracle Database Monitoring

Oracle Database Optimisation

Oracle Database Optimisation
Oracle Database Optimisation

Oracle in the Cloud

Oracle in the Cloud
Oracle in the Cloud

Oracle RAC

Oracle RAC
Oracle RAC

Oracle DR Support

Oracle DR Support
Oracle DR Support