Performance Tuning

Types of Performance Tuning

Application Tuning

Approximately 80% of all Oracle system performance problems are resolved by coding optimal SQL.

Memory & Disk I/O Tuning

Tuning to prevent frequent reloads. Properly sizing of database buffers (shared pool, buffer cache, log buffer, etc) is required. In Disk I/O tuning the files are properly sized and placed to provide maximum disk & sub disk throughput

Eliminate Database Contention

Here we eliminate contentions like database locks, latches and wait events. Data access path, data partitioning, data replication, etc are also taken care

Tuning the Operating system

Here we eliminate contentions like database locks, latches and wait events. Data access path, data partitioning, data replication, etc are also taken care

Code Optimization

It includes improving the code so that not many loops are involved and the code is executed outside the loop wherever possible

Configuration Optimization

Configuration tuning includes improving the performance of the application finding the best configuration for complex applications like Big Data.

Caching strategy

It is used to remove the performance bottleneck. It improves performance by retaining frequently used information in high-speed memory, reducing access time and avoiding repeated computation.

Load Balancing

This arrangement results in the utilization of systems equally for addressing those many service requests, resulting in proper utilization of resources without any system remaining idle.