Five Leading Causes of Oracle Database Performance Problems
However, there are a small number of basic issues that tend to cause problems on the majority of systems.
Our Tech Tips document describes these issues and discusses methods of identifying them and resolving them.
- Statistics Gathering
- Sga Sizing
- Redo Log Sizing
- Index Usage
- Extent Management