ST02 Red Swaps for Buffer

[Former Member]

Hi,

Our current system is: ECC6, on Windows, Oracle 10g, 64bit.

In ST02, I notice high and red swaps for TableDef, FieldDef, Initial Record, program, CUA, and export/import.

Is this normal? and how should I rectify it?

Buffer	HitRatio%	Alloc	FreeSp	%FreeSP	DirSize	FreeDirEnt	%FreeDir	Swaps	DBAcces
TableDef	98.21	6,795			19,990			2,803,906	3,134,485
FieldDef	96.11	31,564	5,330	17.77	19,990	16,413	82.11	4,371,239	4,376,157
ShortNTAB	99.99	3,625	1,705	56.83	4,997	887	17.75	0	4,110
InitialRecord	58.87	6,625	1,792	29.87	4,997	93	1.86	2,612,579	2,617,491
program	97.98	450,000	947	0.22	112,500	101,977	90.65	7,940,559	23,995,092
CUA	92.77	3,000	240	9.76	1,500	1,411	94.07	20,018,666	470,970
screen	94.96	4,297	19	0.46	2,000	1,646	82.30	220,665	817,815
export/import	76.91	5,000	332	8.10	2,500	1,261	50.44	40,103,810
exp/Imp SHM	95.76	4,096	3,184	94.34	2,000	1,999	99.95	0

SAPMemory	CurrUse%	CurrUse	MaxUse	InMem	OnDisk	SAPCurrCach	HitRatio%
Roll Area	10.97	28,750	47,488	262,144	0	IDs	97.98
Page Area	8.79	23,034	167,568	131,072	131,072	Statement	92.00
Extended Memory	43.63	2,285,568	5,136,384	5,238,784	0		0
Heap Memory		0	0	0	0		0

[former_member188883 · Accepted solution]

Hi ZL,

Some number of object swapping is fine. In your case you need to look into fine tuning following buffers

1) Initial record

2) Export/ Import

For other objects you need to study the pattern of swapping. May be you need to check the history .

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi,

For initial records buffer, may I know how should I tune it?

My current rsdb/ntab/irbdsize is 6000kb,  rsdb/ntab/entrycount is 19990, Dir Size is 4,997, %FreeDir is 1.86.

regards,

zl

[Reagan]

Hello

You need to increase both these parameters to increase InitialRecords

Good Luck

RB

[Former Member]

Hi,

Thanks for the guidelines.

For Export/import, the current DirSize is 2,500 and %Free Dir is 50.44%, allocation is 5,000KB, %Free Sp is 8.10%.

Is it ok for me to change rsdb/obj/buffersize to 6,000KB without changing the rsdb/obj/buffersize?

For initial records buffer, may I know how should I tune?

My current rsdb/ntab/irbdsize is 6000kb,  rsdb/ntab/entrycount is 19990, Dir Size is 4,997, %FreeDir is 1.86.

Thank you.

regards,

zl

[former_member188883]

Hi,

You can change the value rsdb/obj/buffersize. Post changes please check whether the SAP shared memory is large enough to hold the new values.

You may check this using

sappfpar check pf=<path of instance profile>

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi ZL,

Please note what reagan and Deepak stated is correct 95% is desired hit ratio.

SAP expects 80% also 10% of your buffer should be free per note Note 373986 - Overflow of the export/import buffer which has more detail.

Kind Regards,

Johan

[Sriram2009]

Hi

Kindly follow the Sap Note 88416 - Zero administration memory management

Thanks

Sriram

[Former Member]

Keep an eye on Hit Ratio as far as it is greater than or equal to 95% it is OK .

increase parameters of Export and Initial Record

[Reagan]

Hello

What matters is the Hit Ratio.

Anything with a hit ratio which is below 95 % can be increased.

I would suggest you to increase InitialRecord and export/import buffers by 30%

Good Luck

RB