on 06-03-2013 9:06 AM
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 | ||
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.