Tuning Oracle Database

There many ways to tuning oracle database, one of them by using third party application. The name is Toad . I use Toad version 9.7.0.51.

Toad has many features, we need these three feature at minimum.

1. ADDM/ADDR Reports
   
   
   
   • Location : Database - Monitor - ADDM/AWR Reports
   
   
   • Function : It will tell us if any slow query appears. So we need to check the query then.


2. Oracle Tuning Advisor
   
   
   
   • Location : Database - Optimize - Oracle Tuning Advisor
   
   
   • Function : It will tess how to tune query. We neet do know query before and write on it. Then OTA will explain tune posibilities for query. For example : create index, remove sub-query, etc.


3. Session Browser
   
   
   
   • Location : Database - Monitor - Session Browse
   
   
   • Function : It help when we need watch running query online. We need execute program who slow performance then we need to see every query on it.

There many ways to tune database, I will write it later.