What causes poor database performance?
[ Return to Table of Contents ] The most common causes of Oracle performance problems are applications that cause the database engine to do much more work than is necessary to achieve the desired result; poorly-designed database schemas; and poorly-designed databases. These can manifest themselves in many ways: excessive CPU consumption due to too many logical I/Os (visits to database blocks in memory), excessive disk reads due to missing indexes, or excessive contention for shared resources.
Related Questions
- What are some fuel-handling causes of poor diesel engine performance?
- What are some fuel-handling causes of poor diesel engine performance?
- What are the causes of poor performance of the HYDROVANE?
- What causes poor performance at INSERT statements?
- What causes poor performance at INSERT statements?
- What causes poor database performance?
