Please advise to increase the oracle data buffer quality from 96% to 99.7%

[Former Member]

Dears,

1.Current system oracle data buffer quality is 96%, if want to increase to 99.7%,

some db parameters as below, how to tuning the related parameters ?

SGA = 48G

PGA = 12 G

Db_cache = 19840M

Shared_pool_size=4G

2, ST02 shows some red colour's swap for some buffer, how to avoid it to happened ?

which parameter need to tuning ?

Thanks,

Michael

[Former Member]

Hello Michael,

If you want to increase the data buffer quality, you have to tune your database. There are many database parameters those need to be taken care. As it has been suggested, good place to start with Early Watch Report, that you can configure in your Solution Manager system and you can get the report and analyse it.

If you are not familiar how to configure Early Watch Alert, below is the wiki document can help you (check you SAP Solution Manager Version):

Create EarlyWatch Alert in solution manager 7.1 - SAP Solution Manager Setup - SCN Wiki

Some of the SAP notes could be helpful for your analysis.

SAP Note 619188 FAQ: Oracle wait events

SAP Note 766349 FAQ: Oracle SQL optimization

SAP Note 767414 FAQ: Oracle latches

Also, you might look into the below links that provide the information you are looking for:

http://scn.sap.com/thread/1872986

http://www.sap-perf.ca/use-sap-st04-for-performance-analysis/

You might have to take help from oracle documentation as well.

Let me know if it helps.

Regards,

Sujit Kumar Banerjee.

[divyanshu_srivastava3]

Hi Michael,

Get the EWA report of this system and follow the recommendations to tune your DB.

That should be your starting point, for now.

Regards,

[Former Member]

Hi Divyanshu,

You mean we could get the EWA report from solution manager system ? or we need ask SAP to send us the EWA report ?

Thanks,

Michael

[divyanshu_srivastava3]

from solman.

[Former Member]

Dear

You need configure your system with solution manager system for EWA report you can schedule EWA report for every week or fortnight then it will generate report according to your choice then you can make changes to system as per the EWA report

Regards

[Former Member]

Hello Michel

Form oracle could please provide the below parameter values,connect to oracle and just type below command and paste the screen,If AMM(Automatic Memory Management) is enabled in your oracle then there are some views which gives the correct values for dba_cache_size and sga_max_size in the system based on the load and the view are V$SGA_TARGET_ADVICE,V$DB_CACHE_ADVICE.Please read

http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11011

http://www.dba-oracle.com/oracle_tips_data_cache_advice.htm

Thanks