Oracle Database Tuning

For optimum performance an Oracle database should be regularly tuned. Only tune a database after it has been up and running for a little while.

Tuning the cache hit ratio
Tuning the library cache
Tuning the log buffer
Tuning buffer cache hit ratio
Tuning sorts
Tuning rollback segments
Identifying missing indexes
Identifying index fragmentation
Identifying free list contention
Identify significant reparsing of SQL
Reducing database fragmentation
Rebuilding indexes
Reduce thrashing or poor system performance (or how to un-tune oracle?!)

I believe these notes to be complete and correct, but if you find any errors or omissions then please let me know (brian@cryer.co.uk).

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.