Slow Performance of SAP ERP 6.0

[former_member215439]

Hi Experts,

     Memory Status

     Main:

     Free physical memory: 36,997,140KB

     Free swap size: 116,247,096KB

     Appserver1:

     Free physical memory: 16,817,284KB

     Free swap size: 38,258,968KB

     Appserver2:

     Free physical memory: 17,000,212KB

     Free swap size: 40,295,084KB

     I just notice when filtering, creating user, deleting user, editing user, and transporting it takes time to load.

     I don't know how to boost the performance. Please Help

[former_member182657]

Hi James,

I just started as SAP BASIS.

Hope you searched before asking ,anyways you could refer some good SCN documents related with your query and i suggest you to follow below SCN links with to resolve your issue.

1.

I didnt run SGEN, I still dont know what is SGEN.

2.

How to check those tablespaces??

3. Run the Update stats and Analyze tables job in your DB

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6b8d972f-0d01-0010-f281-b8178703f...

Hope this will help you.

Regards,

[Former Member]

hello James,

what is the DB underlying ERP 6.0

Regards

Anand

[former_member215439]

We're using oracle db 11g

[manumohandas82]

Hi James  ,

Please share the ST02 screenshot of  the application server you normally logon to .

Also ST02 -> Go To -> Profile Parameters -> Current

Thanks ,

Manu

[Former Member]

Hi James,

Also have you ran SGEN in your system so that the compilation will not happen when you run transactions.

Do check your UNDO & TEMP tablespaces based on your DB should be equal to 75% of your biggest table.

Run the Update stats and Analyze tables job in your DB.

Also do send us the details you see in response time, DB cache hit ratio so we can guide you further.

REgards,

Ram

[former_member215439]

Hi Sir Ram,

     I just started as SAP BASIS.

1. Also have you ran SGEN in your system so that the compilation will not happen when you run transactions.

>>I didnt run SGEN, I still dont know what is SGEN. if you dont mind explain it to me or give me SAP note      about it

2. Do check your UNDO & TEMP tablespaces based on your DB should be equal to 75% of your biggest table.

>> How to check those tablespaces??

3. Run the Update stats and Analyze tables job in your DB.

>> How can I run it?

4. Also do send us the details you see in response time, DB cache hit ratio so we can guide you further.

>> What is the T-code for that?

I really appreciate your answers, please help me I'm just a newbie in SAP world.

Thanks a lot!!!

[former_member215439]

Hi Sir Manu,

Program buffer	PXA
abap/buffersize	800000	kB
abap/pxa	shared

CUA buffer	CUA
rsdb/cua/buffersize	10000	kB

The number of max. buffered CUA objects is al

Screen buffer

PRES

zcsa/presentation_buffer_area 20579328   Byte

sap/bufdir_entries

2000

Generic key table buffer	TABL
zcsa/table_buffer_area	100000768  Byte
zcsa/db_max_buftab	5000

Single record table buffer	TABLP
rtbb/buffer_length	40000	kB
rtbb/max_tables	500

Export/import buffer	EIBUF
rsdb/obj/buffersize	4096	kB
rsdb/obj/max_objects	2000
rsdb/obj/large_object_size	8192	Bytes
rsdb/obj/mutex_n	0

OTR buffer	OTR
rsdb/otr/buffersize_kb	4096	kB
rsdb/otr/max_objects	2000
rsdb/otr/mutex_n	0

Exp/Imp SHM buffer	ESM
rsdb/esm/buffersize_kb	4096	kB
rsdb/esm/max_objects	2000
rsdb/esm/large_object_size	8192	Bytes
rsdb/esm/mutex_n	0

Table definition buffer

TTAB

rsdb/ntab/entrycount

200000 ztta/roll_area            2000000 Byte ztta/roll_first           1024   Byte ztta/short_area           3200000 Byte rdisp/ROLL_SHM            16384  8 kB rdisp/PG_SHM              16384  8 kB rdisp/PG_LOCAL            150    8 kB em/initial_size_MB        10240  MB em/blocksize_KB           4096   kB em/address_space_MB       4096   MB ztta/roll_extension       2000683008 Byte abap/heap_area_dia        2000683008 Byte abap/heap_area_nondia     2000000000 Byte abap/heap_area_total      2000000000 Byte abap/heaplimit            40894464   Byte abap/use_paging           0

Please see thanks