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 behaviour 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 220.127.116.11
- Oracle database 18.104.22.168
- Oracle database 22.214.171.124
- Oracle database 126.96.36.199
- Oracle database 188.8.131.52
- Oracle database 184.108.40.206
- 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 , KBA , BC-DB-ORA , Oracle , SV-PERF-DB-ORA , Performance messages related to Oracle databases , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.