on 12-05-2006 10:09 AM
Hi All,
I facing problem with swap space, due to this some time response time is too much. Platform is ECC 6.0 (unicode) WIN 2003/Ora 10 G, ram size is 4 GB and paging in 6 partitions is 1024-2048.
Swaps
0
0
5.754
0
2.749
0
6.856
5.571
615
0
0
0
0
55
2
0
5.167
0
SAPSYSTEMNAME TT1
SAPGLOBALHOST tppls1132
SAPSYSTEM 00
INSTANCE_NAME DVEBMGS00
DIR_CT_RUN $(DIR_EXE_ROOT)\$(OS_UNICODE
DIR_EXECUTABLE $(DIR_INSTANCE)\exe
PHYS_MEMSIZE 512
rdisp/wp_no_dia 4
rdisp/wp_no_btc 1
icm/server_port_0 PROT=HTTP,PORT=80$$
ms/server_port_0 PROT=HTTP,PORT=81$$
rdisp/wp_no_enq 1
rdisp/wp_no_vb 1
rdisp/wp_no_vb2 1
rdisp/wp_no_spo 1
DIR_CLIENT_ORAHOME $(DIR_EXECUTABLE)
login/no_automatic_user_sapstar 0
rsdb/ntab/entrycount 30000
abap/fieldexit yes
abap/heap_area_dia 776480000
abap/heap_area_nondia 776480000
rdisp/max_wprun_time 600
zcsa/table_buffer_area 30000000
rtbb/buffer_length 10000
rsdb/cua/buffersize 3000
rsdb/obj/max_objects 2000
abap/buffersize 300000
Kindly suggest me the tunnig measures I have to follow. I have changed some parameters but unable to resolve the issue.
With regards,
Amit
Hi Amit
Buffer the tables on which queries are generated. This would reduce the number of swaps.
Try to find out the most expensive statements and see if there are some missing indexes.
If your RAM size is not large enough you need to increase depending on the database size.
You can also try to implement logon groups to increase the cache hits.
Hope that helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I think its problem with your paging file size
paging should be 1gb+ 3 times RAM ( for 32 bit)
Change this and restart the system
Regards,
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Sorry i forgot to tell you some thing
After you change the Paging file, make sure your PHYS_MEMSIZE should be
50% to 70% of the RAM size and also change these parameters
[HS] = size of the physical main memory
[PM] = value of the profile parameter PHYS_MEMSIZE (standard value=[HS])
[BE] = maximum possible number of users (calculated from [PM])
em/initial_size_MB = [PM] |Mbyte |
em/max_size_MB = 20000 |Mbyte |
em/address_space_MB = 512 |Mbyte |
ztta/roll_first = 1 |Byte |
ztta/roll_area = 2000000 |Byte |
ztta/roll_extension = 2000000000 |Byte |
abap/heap_area_dia = 2000000000 |Byte |
abap/heap_area_nondia = 2000000000 |Byte |
abap/heap_area_total = 2000000000 |Byte |
rdisp/ROLL_MAXFS = [BE] * 100 |8KB Block |
rdisp/ROLL_SHM = [BE] * 100 | [BE] * 100 |8KB Block |
rdisp/PG_MAXFS =32768 |8KB Block |
rdisp/PG_SHM = [BE] * 50
Regards
Phani
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.