As we evaluate our clients’ Oracle databases and help them solve problems relating to performance and stability, we see many causes for these issues.
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.
Topics include:
- Statistics Gathering
- Sga Sizing
- Redo Log Sizing
- Index Usage
- Extent Management