Oracle Health Check

An Oracle health check is a fast, efficient service that aims to review all main aspects of your database or application infrastructure. By identifying any bottlenecks or performance issues and then providing fast remedial action, this is a sensible and cost-effective route to maintaining maximum application efficiency.

Our health checks use a combination of leading edge Oracle monitoring tools and bespoke scripts, along with all the practical experience and incident libraries that our consultants have gained over the past 10 years.

Further to our review we will produce a report that provides comprehensive diagnostics and will make practical recommendations for any performance or configuration optimisation. Many organisations decide to have an independent assessment of this nature carried out on a regular basis, whether for compliance purposes or just for additional peace of mind.

An Oracle Health Check service is for you if:-

  • You experience regular application or database performance degradation.
  • You do not perform regular database maintenance.
  • You are about to perform an upgrade or migration.
  • You are concerned about future capacity and need to plan for the future.
  • You are concerned about database security or have compliance issues.
  • You have regular issues with database backup and recovery.

Oracle Health Check at a glance

The following elements will be reviewed and assessed during a health check or performance review. A typical service takes 3 days, where 2 days are spent on-site with a further day to interpret results and create the bespoke report.

Environment

Backup and Recovery, Capacity planning, Alignment of database & application to business needs

Hardware and O/S

Analysis of RAID Configuration, Hardware Capacity Planning, Memory / CPU Benchmarking, Server Specification, File System Configuration, Patch levels, Network Interfaces

Instance Analysis

I/O Activity, Current Data Block Buffer usage, Data Dictionary Cache Statistics, Shared SQL Pool Area statistics, Log Buffer Statistics

Management Statistics

Tablespace fragmentation statistics, Segment fragmentation statistics, Free space fragmentation statistics, Overall Data Dictionary Overhead, Calls To The Data Dictionary, Tablespace & Datafile I/O statistics, Tablespace Utilization, I/O Throughput, I/O Bottleneck resolution statistics, Disk Read/Write Rate, Sort status statistics and sort area size utilization, Rollback Segment statistics, Initialization parameter settings, Indexes

Get In Touch







Find us on
  • Linked In
  • Twitter
  • Blog
Quantix Partners