prod. system periodically into swap

[Former Member]

Hi all

I have problem with dialog production instance. Periodically dialog going into swap and when swap is full accordingly instance is not responding.

Configuration:

ECC 5.0 Oracle 9.2 Solaris 10

I want to understand what options are actually used physical memory?

CI 16G RAM + 5.8G Oracle SGA:

ztta/roll_area 3000000 Byte Roll area per workprocess (total)

ztta/roll_first 1 Byte First amount of roll area used in a dialog WP

ztta/short_area 3200000 Byte Short area per workprocess

rdisp/ROLL_SHM 16384 8 kB Part of roll file in shared memory

rdisp/PG_SHM 8192 8 kB Part of paging file in shared memory

rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess

em/initial_size_MB 5000 MB Initial size of extended memory

em/blocksize_KB 4096 kB Size of one extended memory block

em/address_space_MB 4092 MB Address space reserved for ext. mem. (NT only)

ztta/roll_extension 2000000000 Byte Max. extended mem. per session (external mode)

abap/heap_area_dia 90000000 Byte Max. heap memory for dialog workprocesses

abap/heap_area_nondia 2000000000 Byte Max. heap memory for non-dialog workprocesses

abap/heap_area_total 2000000000 Byte Max. usable heap memory

abap/heaplimit 40000000 Byte Workprocess restart limit of heap memory

abap/use_paging 0 Paging for flat tables used (1) or not (0)

dialog 16G RAM:

ztta/roll_area 3000000 Byte Roll area per workprocess (total)

ztta/roll_first 1 Byte First amount of roll area used in a dialog WP

ztta/short_area 3200000 Byte Short area per workprocess

rdisp/ROLL_SHM 16384 8 kB Part of roll file in shared memory

rdisp/PG_SHM 8192 8 kB Part of paging file in shared memory

rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess

em/initial_size_MB 12000 MB Initial size of extended memory

em/blocksize_KB 4096 kB Size of one extended memory block

em/address_space_MB 4092 MB Address space reserved for ext. mem. (NT only)

ztta/roll_extension 2000000000 Byte Max. extended mem. per session (external mode)

abap/heap_area_dia 2000000000 Byte Max. heap memory for dialog workprocesses

abap/heap_area_nondia 2000000000 Byte Max. heap memory for non-dialog workprocesses

abap/heap_area_total 2000000000 Byte Max. usable heap memory

abap/heaplimit 40000000 Byte Workprocess restart limit of heap memory

abap/use_paging 0 Paging for flat tables used (1) or not (0)

In st02 on both prod. instance i have red swaps:

Field description, Initial records, CUA, Screen, Generic Key, Single record, Export/Import.

CI:

Hitratio % = 97.57

90.00

dialog:

Hitratio % = 98.73

87.00

The average number of users per day : CI: 47

dialog 58

Tell me please what could be the problem and how to solve it?

[vincentlim826]

Hi

High swapping in ST02 could points to buffer issue.

Following SAP notes are relevant

1. 480710 - Profile parameters for table buffers

2. 702728 - Profile parameter for export/import buffer instances

3. 8778 - Overflow in the table, single record, and CUA buffers

Regards,

Vincent

[Former Member]

Thanks for answers

[Former Member]

Andrey i can see your system has been configured incorrectly

Your total extended memory for the instance (em/initial_size_MB) is 5GB and maximum extended memory each work process can use is is 2 GB (ztta/roll_extension) . so incase you have 3 work process who want to use 2GB of extended memory you will be already exhausted because your total extended memory is 5 GB.

Below is my recommendation assuming you do not have any other instances on each of the CI and Dialog instance box.

em/initial_size_MB = 12 GB

ztta/roll_extension = 300~600 MB

Heap Area for dialog = 1.5 GB

Heap Area for Non diag = 4 GB

No of diag WP = 20

No of Btc WP = 15

Note : Our normal thought process is we have to multiply no of (diag+BTC) wp and ztta/roll_extension to arrive at a figure for

em/initial_size_MB but that is not the right way of calculating because not all the work process are going to use extended memory only few use them in case some memory consuming reports are ran.

Try them out and let me know. Keep a good luck on ST02 and ST03.

Cheers !

Manish Jain