1817553 - Checklist for performance problems in SAP Oracle Databases | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1817553 - Checklist for performance problems in SAP Oracle Databases

Symptom

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.


Read more...

Environment

  • 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
  • SAP Release independent
  • Operating System independent

Keywords

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 page

This 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.