1817553 - Checklist for performance problems in SAP Oracle Databases

Performance problems occur during different DB activities. And the cause can not be tracked back to a single SQL Statement.

This SAP Knowledge Base Article provides a checklist that are required to minimize the risk of problems caused by:

• Unbalanced Database Setup
• Incorrect Database Parameter Settings

With completing Points 1-6 we can make sure the Oracle Database has been set up as required by SAP. So the Systems behavior and working performance is close to the expected as much as possible.
With the help of Points 7 -10 we can determine where is the most time spent from a performance perspective.

• Oracle database 10.2.0.5
• Oracle database 11.2.0.1
• Oracle database 11.2.0.2
• Oracle database 11.2.0.3
• Oracle database 11.2.0.4
• Oracle database 12.1.0.2
• Oracle database 12.2.0.1
• Oracle database 18c
• Oracle database 19c
• SAP Release independent
• Operating System independent

Automatic Workload Repository, Active Session History, Cost Based Optimizer, Rule Based Optimizer, SAP Bundle Patch, DBBP, WINDBBP, ASH, AWR, PSU, CPU, SPU, slow, performance, drop, issue, hang, problem, lock, upgrade, install, installation, slowness, stuck, freeze, tune, tuning,long_time, long_time_running, poor, bad, loss, technical, optimization, very_slow, quite, increase, increasing, processing_times, serious, seriously, slowing, abnormal, rapid, huge, extreme, rapidly, significant, large, high, raise, raising, expand, expanding, sudden, suddenly, excessive, unusual, very_large, enormous, hate, massive, consume, consuming, decrease, decreased, load, execution, long, response_time, time, fixed object statistics,degrade,degradation, performance degradation, upgrade, patch, ORA-01555, ORA-1555 , KBA , BC-DB-ORA , Oracle , SV-PERF-DB-ORA , Oracle related performance issues , How To