analyzing memory configuration

[Former Member]

HI Guys,

I am trying to analyze memory parameter of my Production Server which is running on RHEL 4 with Oracle 10.2.0.2

this is the output of sappfpar check pf=<Instanceprofile>

Shared memory disposition overview

================================================================

Shared memory pools

Key: 10 Pool

Size configured.....: 132000000 ( 125.9 MB)

Size min. estimated.: 127706956 ( 121.8 MB)

Advised Size........: 130000000 ( 124.0 MB)

Key: 40 Pool for database buffers

Size configured.....: 226000000 ( 215.5 MB)

Size min. estimated.: 221679040 ( 211.4 MB)

Advised Size........: 224000000 ( 213.6 MB)

Shared memories inside of pool 10

Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer

Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.

Key: 13 Size: 60500000 ( 57.7 MB) Alert Area

Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring

Key: 17 Size: 10683916 ( 10.2 MB) Roll administration

Shared memories inside of pool 40

Key: 42 Size: 21312992 ( 20.3 MB) DB TTAB buffer

Key: 43 Size: 107734392 ( 102.7 MB) DB FTAB buffer

Key: 44 Size: 20694392 ( 19.7 MB) DB IREC buffer

Key: 45 Size: 8406392 ( 8.0 MB) DB short nametab buffer

Key: 46 Size: 20480 ( 0.0 MB) DB sync table

Key: 47 Size: 10241024 ( 9.8 MB) DB CUA buffer

Key: 48 Size: 300000 ( 0.3 MB) Number range buffer

Key: 49 Size: 2968344 ( 2.8 MB) Spool admin (SpoolWP+DiaWP)

Shared memories outside of pools

Key: 1 Size: 2500 ( 0.0 MB) System administration

Key: 2 Size: 60783188 ( 58.0 MB) Disp. administration tables

Key: 3 Size: 114048000 ( 108.8 MB) Disp. communication areas

Key: 4 Size: 523648 ( 0.5 MB) statistic area

Key: 6 Size: 1277952000 (1218.7 MB) ABAP program buffer

Key: 7 Size: 14838 ( 0.0 MB) Update task administration

Key: 8 Size: 268435556 ( 256.0 MB) Paging buffer

Key: 9 Size: 268435556 ( 256.0 MB) Roll buffer

Key: 14 Size: 20000000 ( 19.1 MB) Presentation buffer

Key: 18 Size: 3670116 ( 3.5 MB) Paging adminitration

Key: 19 Size: 150000000 ( 143.0 MB) Table-buffer

Key: 30 Size: 37888 ( 0.0 MB) Taskhandler runtime admin.

Key: 31 Size: 4206000 ( 4.0 MB) Dispatcher request queue

Key: 33 Size: 61440000 ( 58.6 MB) Table buffer, part.buffering

Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer

Key: 51 Size: 3200000 ( 3.1 MB) Extended memory admin.

Key: 52 Size: 40000 ( 0.0 MB) Message Server buffer

Key: 54 Size: 40968192 ( 39.1 MB) Export/Import buffer

Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist

Key: 57 Size: 1048576 ( 1.0 MB) Profilparameter in shared mem

Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset

Key: 62 Size: 85983232 ( 82.0 MB) Memory pipes

Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory

Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.

Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory

Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0

Key: 58900100 Size: 4096 ( 0.0 MB) SCSA area

Nr of operating system shared memory segments: 29

Shared memory resource requirements estimated

================================================================

Total Nr of shared segments required.....: 29

System-imposed number of shared memories.: 1000

Shared memory segment size required min..: 1277952000 (1218.7 MB)

System-imposed maximum segment size......: 23085449216 (22016.0 MB)

Swap space requirements estimated

================================================

Shared memory....................: 2623.6 MB

..in pool 10 121.8 MB, 96% used

..in pool 40 211.4 MB, 98% used

..not in pool: 2284.1 MB

Processes........................: 507.3 MB

Extended Memory .................: 10240.0 MB

-

---

Total, minimum requirement.......: 13370.9 MB

Process local heaps, worst case..: 5722.0 MB

Total, worst case requirement....: 19093.0 MB

Errors detected..................: 0

My question is related to shared memory, i mean it is showing pool10 96% and pool40 98% used. so what i need to do. How can i analyze the log.

can amyone guide me to understand these logs.

Regards

Subhash

[hannes_kuehnemund · Accepted solution]

Dear Subhash,

the SAP Knowledge Warehouse, Chapter [Memory Management|broken link] will give you the complete and comprehensive overview of the SAP Memory Management.

Thanks,

Hannes

Edited by: Hannes Kuehnemund on Dec 2, 2008 8:23 AM

[Former Member · Accepted solution]

Hello Hannes,

I am not able to open this link, as this page cannot be displayed. Is there any other way to go to this link.

Regards

Subhash

[hannes_kuehnemund · Accepted solution]

Sorry,

this is the correct link:

[http://help.sap.com/saphelp_nw70/helpdata/EN/02/962acd538111d1891b0000e8322f96/frameset.htm|http://help.sap.com/saphelp_nw70/helpdata/EN/02/962acd538111d1891b0000e8322f96/frameset.htm]

Thanks,

Hannes