Oracle Database Performance Tuning2017-10-21T04:33:34+00:00

Assess, tune, and configure Oracle database and dependent systems for optimum performance

Oracle Performance Tuning Services help identify performance problems in the holistic systems infrastructure depending on Oracle databases. We examine application server, database server, storage, and network performance to identify, tune, and remediate issues that are impeding peak performance and delivery of infrastructure service quality

Oracle Performance Tuning Services consist of three service areas:

  • Holistic Systems Assessment
  • Recommendations and Remediation Planning
  • Performance Tuning

Assessment Methodology

We gain a deep understanding of the Oracle environment with a focus on the performance problems or known issues that may exist. Oracle performance management experts work with key client team members to identify any cross functional problems and knowledge gaps. Using specially developed and standard toolsets, our performance engineers then analyze systems performance, including:

  • Server hardware and storage configuration and RAID levels
  • Systems resource utilization – memory, CPU, disk I/O data
  • Oracle configuration and parameter settings, and OS configuration
  • Oracle performance data and statistics
  • Execution plans
  • Oracle database configuration and file layout
  • Maintenance plans and jobs
  • Backup/recovery
  • SQL code
  • Other processes and applications
  • Resource waits and process blocking

Recommendations and Action Plan 

After careful analysis and identification of key problem areas, the project team will then provide data-driven and specific recommendations and best practices for performance improvements, including configuration of the Oracle database, operating system, and server and storage systems and ways to remediate performance bottlenecks. Working with your team, we will outline a project plan to address each problem area, prioritizing them by level of effort, risk, and potential business and performance payoff. With agreement on the highest priority areas to address, our engineers will begin to assist in performance tuning the systems. 

Performance Tuning

Once an action plan is developed, performance tuning will be performed on the agreed-upon highest priority remediation tasks as project scope and time permits. PTC’s proven tuning methodology starts with the development of a validation plan and documentation of expected results. Changes are implemented one at a time, measured, and validated against the plan. These may include configuration parameter change, hardware changes, adding indexes, and process changes. The solution is validated and tested in a non-production environment wherever possible, including load testing if appropriate.

Latest From the Blog

Configuring a PDB for Comparison in Oracle Veridata

Edward Whalen 04/16/2019 Oracle GoldenGate Veridata - Configuring a PDB for Comparison in Oracle Veridata I recently came across an interesting problem.  How do you point the Oracle Veridata Agent at an Oracle pluggable [...]

Tuning Oracle Veridata

Edward Whalen 03/21/2019 Oracle GoldenGate Veridata - Tuning Oracle Veridata Oracle GoldenGate Veridata is the most effective tool for comparing, validating and repairing data between homogeneous and heterogeneous databases.  As powerful as it is, [...]

Setting up GoldenGate Replication with DIPC

Edward Whalen 03/07/2019 Setting up GoldenGate replication with DIPC is done from both the cloud console and from the GoldenGate home.  In this example I will be using an Oracle database source and an [...]

What Our Clients Say

“Performance Tuning was able to quickly troubleshoot and resolve many technical issues that often eluded other consulting companies we’ve worked with. I was most impressed by their quick response in emergency situations. They’ ve been instrumental in the delivery of Oracle technologies such as Oracle RAC, Grid Control and Data Guard.”

James Jech, Dell

“Performance Tuning was able to offer unique insights to database design and performance tuning optimization on a world class level. They did a superb job of load testing, which was cited by Microsoft (a team member) as, the best we’ve seen in three years and 50 customers to come through our SQL Server Performance Tuning Lab. This statement came from the SQL Server Product Group in Redmond – a tough crowd to please. In addition, they accelerated several products including our flagship Thomson ONE Analytics and were a key part of a project whose success has lead to case studies by Intel, Microsoft, and Unisys.”

Jeremy Lehman, Thomson

“The Instructor was able to customize the course slightly to meet the needs and levels of experience in the class. It was great to get some real hands on to cement in what was reviewed and explained.”

Chad Aberle, Microsoft

“We recently had a problem with SQL Server performance after introducing virtualization and a SAN in our server environment. After working with two different consulting companies without success, we contacted Performance Tuning Corporation. PTC rapidly set up a remote engagement with us, and within one week was able to identify a problem with a virtual device driver. We are very satisfied with the work PFC performed, and feel it is some of the best consulting money that we have spent in several years.”

Howard Brill, PHD, Monroe Plan

PTC has been phenomenal. It’s a scary time when your most critical data is being moved while users are in the system working. Especially on the heals of our previous vendor’s failed attempt. I can only describe it as a calming effect when true professionals are running the show.

IT Healthcare Manager, Opelousas General Health System

“We are very pleased with the work that PTC performed. They were able to extract information from SQL Server and use that information to identify the exact causes of our performance bottlenecks. They provided us with information, tools, and instructions on how we can locate the cause of our performance problems. The final report contained good information and gives us a benchmark for doing future performance reviews.”

Jon Robertson, MedEvolve

“This is a well balanced course (Optimizing Oracle RAC on Linux) covering all major topics from System Administration to Database Administration unlike most of the courses”

Manish Bijlani, RealtyData Corp.

Our Clients

Over 1000 clients from all industries have benefitted from our database services