Here are the questions surrounding about Tuning:
- The part where the need do tuning. Who do?
- From the application, what the need do tuning?
- The database which need to do tuning?
- Where we can learn a lot about Tuning?
The part where the need do tuning? By whom?
- Applications, by the application designer and developer
- Database, database administrator (DBA)
- Operating System (OS), by the system administrator (sysadmin)
Tuning Applications
Tuning applications are contributing to the overall system performance. Including part-Tuning the application are:
- Normalisasi appropriate
- Use index
- Hint in the use of SQL queries or PL / SQL
- Utilization sharing cursor
- and other
The database which need to do tuning?
- Memory -> PGA SGA and SGA (shared pool, a large pool, the buffer cache, Redo log buffer, sort area size)
- I/O -> distributing I / O, striping, multiple DBWn Processes, DBWn I / O slaves.
- CPU -> CPU Utilization.
- Network
- Space management -> Oracle extent allocation and block efficiency.
- Redo logs and Checkpoint -> Redo log file configuration, Redo entries, and Checkpoint.
- Rollback segment -> sizing rollback segments. Commercial versions 9i, banyakbagian made automatic
- and other
Where we can learn a lot about Tuning?
- Oracle8i Designing and Tuning for Performance Release 2 (8.1.6)
- Oracle9i Database Performance Planning Release 2 (9.2)
- Oracle9i Database Performance Tuning Guide and Reference Release 2 (9.2)
- Oracle® Database 2 Day + Performance Tuning Guide 10g Release 2 (10.2)
- Oracle® Database Performance Tuning Guide 10g Release 2 (10.2)
- Oracle® Database 2 Day + Performance Tuning Guide 11g Release 1 (11.1)
- Oracle® Database Performance Tuning Guide 11g Release 1 (11.1)