Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
0 Kudos

                     SAP Performance tuning with Oracle 11G in OS/ Linux


This document contains how to tune the parameters in SAP level as well in database level based on your hardware, SAP application and database configuration.

Author: Brindavan Mookaiah

Designation: SAP BASIS Consultant


The information about the parameters which show here are after analysis from our system landscape. It might be different from your landscape. If you are facing any performance issue in your system then you should analysis first for past three months data like response  time, CPU utilization , database load , new z*program ,expensive SQL statement ,snote , might be if user access backend system from portal..etc…  . This document only shows how to analysis and do the tuning based on the hardware, SAP application and database. We have analyzed and found that nothing can be increased any hardware or update patches or any z*program created by ABAP developers (include any new variants on existing z*program) or any expansive SQL statement using like “join queries ,using selection screen more” are causing performance issue.  Here we have the system performance is fine and something slowness for background process. But, system is not overloaded with any new SAP application changes, so we have to analysis and tune the parameters based on current RAM.

SAP Application: SOLAMAN 7.1

OS :  Red hat Linux

Database               : Oracle 11G

While checking from hardware side we have found that the system is configured with good memory running with 200 MB frees space and there is no way to improve the performance without adding the RAM. Before going to add the Ram we planned to use another method, that means we have checked and analysis where it causing the performance issue to tune.  Gone through some T0-code like from SAP level ST02,DB02,ST03,EWA report expensive SQL statement..etc.. but we found in initial stage that in DB02 that the database buffer quality area is 94.6  , as per SAP recommendation this buffer quality should be more than 99.* The database buffer quality issue is due the memory  configured very lees for SGA,PGA,DATABASE_BUFFER_CACHE, SAHRED_POOL_SIZE..etc.

Now we identified the issue and need some memory to tune, but we don’t have memory for the same. So, we followed another method and analysis   what are the memory area which is not utilized from SAP level and shared to database as well to SAP another parameters to tune.  We found some memory and tuned the same. 

Find the below plan for your knowledge.

SystemInstanceMonthTotal Memory Available (GB)Total Memory Used Max(GB)DB Cache Memory Configured (MB)DB Buffer Quality (%)Shared Pool Memory Configured_MBSGA (GB)PGA(MB)
SOLMANSAP Database35.3335.1680094.64721.48332
New Value122411072.48358

Profile parameterStandard 64-bitCurrent ValueUnit:New Value
em/max_size_MB1.5 * [PM]4096MB
rdisp/ROLL_MAXFS[US] * 100327688KB block262144
rdisp/ROLL_SHM[US] * 100163848KB block131072
rdisp/PG_MAXFS32768327688KB block262144
rdisp/PG_SHM[US] * 5081928KB block65536
ztta/roll_extension MB4000683008bytes2007600000

After tuning the parameter the system behaviour bit faster than before e and database buffer quality is 99.4.  This some way managed to tune the parameter in worst case without adding the RAM. Mostly you have to check for latest patches, expansive SQL statement ,hardware side, memory side , CPU ..etc.. First need to identified the performance issue where its come from, then based on that you can tune for the same.

Reference OSS notes:-

941735 - SAP memory management system for 64-bit Linux systems

425207 - SAP memory management, current parameter ranges

146289 - Parameter Recommendations for 64-Bit SAP Kernel

789477 - Large extended memory on AIX (64-bit)

1171650 - Automated Oracle DB parameter check

Labels in this area