Site icon IT Tutorial

Introduction to Performance Management and Tuning in Oracle | Oracle Database Performance Tuning Tutorial -1

Hi,

I will explain Introduction to Performance Management and Tuning in this Oracle Database Performance Tuning Tutorial series.

 

Performance Management and Tuning in Oracle

 

Before start to reading Oracle Performance Tuning tutorial, you need to complete Oracle database tutorials for beginners. You can read them at the following link.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

It is expected to solve performance issues by DBA ( Database Administrator ) when performance complaints in the Oracle database begin to increase.

The purpose of Performance tuning is as follows.

Minimizing response time
Increasing throughput
Increasing load capabilities
Reducing recovery time

 

Before start to solve the performance issue, you need to determine what the problems are and how to solve them.

The solution of performance problems are done in the 3 categories.

 

Oracle Monitoring and diagnostics

To start Performance tuning, you should firstly do Monitoring and diagnostics step to define if problem exists or not and what is the problem. Monitoring and diagnostics step includes the monitoring, diagnostic, and reporting tools that Database administrator is used to identify proactively performance problems. DBA cannot start performance tuning without Monitoring and diagnostics.

 

Instance tuning

This step includes memory,  I/O and space management. This division covers using the diagnostic tools to determine the specific problem area and
implement a solution.

 

SQL tuning

Once first and second steps are completed, SQL Tuning should be started. SQL Tuning should be done high-load SQL statements, badly writen SQL statements.

 

 

Performance tuning task is done like the following triangle steps. Start Performance tuning from the top and go on from the TOP to Down.

 

Performance tuning steps should be as follows.

 

1. Identify the problem (OS, database or SQL Statement).

2. Check Operating System

3. Check Database

 

4. Check SQL Statement

 

In the Next tutorial series, I will explain each step in detail and as a Article.

 

Next post link about Performance Tuning Tutorial is as follows.

Performance Tuning Features and Tools in Oracle | Oracle Database Performance Tuning Tutorial -2

 

 

 

 

Do you want to learn Top 30 SQL Tuning Tips and Tricks, then read the following articles.

SQL Tuning Tips and Tricks Tutorial in Oracle -3

Exit mobile version