Veldkant 31,
Kontich,   2550 Belgium
www.exitas.be

Solution Name

Performance Tuning

Solution Summary

Sometimes a system performs badly. Or just not as well as you had hoped or expected and the reason why is not immediately obvious to those working with it. We specialize in Oracle Database performance and the many influencers around it that underlie poor performance.

Besides solving current performance problems, we also recommend proactive tuning, which has the following advantages:

  • Optimal sizing when buying new hardware.
  • A comprehensive insight in DB activity.
  • The elimination of unnecessary resources usage.
  • An optimization of systems in order to reduce or stabilize the license cost.

 

Solution Profile

Our tuning expertise

Our areas of tuning expertise are:

  • DB activity:
    • CPU.
    • I/O.
    • Memory.
    • Wait events.
    • Locking.
  • OS activity:
    • CPU.
    • Memory.
    • Storage.

First we look at overall DB performance, though individual queries and action can be evaluated as a second step as well.

How we do it

We take the following steps to come to our findings and recommendations concerning your performance issues:

Phase 1: Scope & Objectives.

Define the DBs and systems where the problem occurs.

Describe the current architecture (clustering, storage configuration, application servers,…).

Define the purpose of the analysis (HW renewal, issues, consolidation, license cost, …).

Phase 2: Configure the tools.

Apart from using the existing Oracle tools such as AWR, we also have our own monitoring and reporting tools, designed specifically for reading the DB environment in detail and report comprehensively on these measurements:

Plato (tool): gives an overview of the actual structure and settings of the DB.

Pandora (tool): collects and visualizes key performance statistics over time.

Phase 3: Sampling period (minimum one week is recommended).

Phase 4: Analysis.

Creation of the report of findings:

Deep insight in actual DB performance.

Overview of highest resource usage.

Recommendations & quick wins:

Interesting areas for tuning.

Architecture, DB versions, …

DB settings and features.

OS parameters.

Storage configuration.

Phase 5: Presentation & Discussion.

Phase 6: Recurring evaluation (optional).

Distinguishing Features


Expertise

Exitas has deep and unique expertise in the evaluation of Oracle database performance. The approach can be done in 2 ways: either by doing a global evaluation of the environment, trying to identify possible bottlenecks, or by investigating a specific performance problem, indicated by you.

Experience

Our experts rely on years of experience, the latest tool sets, and a sound methodology to help you in this complex and challenging area.

Solution Name

Performance Tuning

Solution Availability

Europe, Middle East, Africa

Industries

  • Non-Industry Specific

Oracle Products

  • Database
  • Operating Systems

Company Size Solution is Targeting

No data available.

Open Source Solutions

No data available.

About Exitas NV

banner

Exitas is an ICT provider of hardware, software and services. We provide organizations with resources to build the IT-infrastructure they envision. We can help you in designing your environment, implement it and run solutions across the entire technology stack, from hardware all the way up to customized all-in solutions. Exitas has been the Belgian market leader for the last 15 years for Oracle Databases and System Administration. We continue to grow in both expertise as well as in solutions. Being an Oracle Partner, we continue to focus and specialize, enabling us to deliver projects with expertise and commitment.

 

View Partner Profile

The partners listed in the Oracle PartnerNetwork (OPN) Solutions Catalog are part of the Oracle PartnerNetwork Program, however Oracle does not endorse any of the partners or their software, solutions, services or training listed on this site. Oracle disclaims any and all liability arising out of your use of the Oracle PartnerNetwork Solutions Catalog, including use of partners, software, solutions, services and training listed on the site.