SAP Knowledge Base Article - Preview

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
  • Oracle database
  • Oracle database
  • Oracle database
  • Oracle database
  • Oracle database
  • Oracle database
  • 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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.