Five Leading Causes of Oracle Database Performance Problems
Posted by Bob Buda on Thu, Feb 03, 2011 @ 05:25 AM
As we evaluate our clients’ Oracle database systems 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
Download our Tech Tips document