Skip to Content
avatar image
Former Member

Memory issue

Hi All,

We are having frequent issues where the memory is being consumed fully.

We have 16 gb of ram.

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

== Checking profile: prd_DVEBMGS52_sapprd

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

***WARNING: Unexpected parameter: auth/auth_number_in_userbuffer =9000

***WARNING: Unexpected parameter: auth/test_mode =N

***WARNING: Unexpected parameter: system/type =ABAP

***ERROR: /dev/shm is too small (19264 MB required, 8008 MB configured)

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_0 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_1 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_2 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_3 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_4 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_5 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_6 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_7 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_8 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_9 with 841 MB

Shared memory disposition overview

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

Shared memory pools

Key: 10 Pool

Size configured.....: 200000000 ( 190.7 MB)

Size min. estimated.: 128139520 ( 122.2 MB)

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

Key: 40 Pool for database buffers

Size configured.....: 184000000 ( 175.5 MB)

Size min. estimated.: 178871040 ( 170.6 MB)

Advised Size........: 182000000 ( 173.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: 11116480 ( 10.6 MB) Roll administration

Shared memories inside of pool 40

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

Key: 43 Size: 66774392 ( 63.7 MB) DB FTAB buffer

Key: 44 Size: 13526392 ( 12.9 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: 15361024 ( 14.6 MB) DB CUA buffer

Key: 48 Size: 500000 ( 0.5 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: 60839260 ( 58.0 MB) Disp. administration tables

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

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

Key: 6 Size: 638976000 ( 609.4 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: 70656 ( 0.1 MB) Taskhandler runtime admin.

Key: 31 Size: 4806000 ( 4.6 MB) Dispatcher request queue

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

Key: 34 Size: 30720000 ( 29.3 MB) Enqueue table

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: 76 Size: 1586464 ( 1.5 MB) ?????????????

Key: 77 Size: 518432 ( 0.5 MB) ?????????????

Key: 78 Size: 500256 ( 0.5 MB) ?????????????

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

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

Nr of operating system shared memory segments: 33

Shared memory resource requirements estimated

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

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

System-imposed number of shared memories.: 1000

Shared memory segment size required min..: 638976000 ( 609.4 MB)

System-imposed maximum segment size......: 14025752576 (13376.0 MB)

Swap space requirements estimated

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

Shared memory....................: 2008.5 MB

..in pool 10 122.2 MB, 64% used

..in pool 40 170.6 MB, 97% used

..not in pool: 1707.2 MB

Processes........................: 897.9 MB

Extended Memory .................: 7788.0 MB

Extended Memory 2 ...............: 19264.0 MB

.. 70 VMs, 1048.0 MB address space

-


Total, minimum requirement.......: 29958.4 MB

Process local heaps, worst case..: 28610.2 MB

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

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

Warnings detected................: 3

sapkxpsrmdb01:prdadm 4> free -m

total used free shared buffers cached

Mem: 16023 15474 548 0 174 11794

-/+ buffers/cache: 3505 12518

Swap: 21599 3717 17882

Oracle memory areas

SQL> show sga

Total System Global Area 4714397696 bytes

Fixed Size 2090240 bytes

Variable Size 2415921920 bytes

Database Buffers 2281701376 bytes

Redo Buffers 14684160 bytes

SQL> show parameter pga

NAME TYPE VALUE

-


-


-


pga_aggregate_target big integer 3407200911

SQL>

Why is that we are running out of memory even though we have enough RAM to accomodate oracle and SAP and linux OS requirements?

I wanted to know as what exactly the sappfpar reports? and PGA will be allocated on demand right?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 24, 2011 at 11:00 AM

    Hi,

    could you paste the int<sid>.ora or spfile.ora

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      *.shared_pool_size=2272002048

      2.2GB is huge unless there is an Oracle requirement on LINUX.

      you can scale this right back by at least 1.6GB.

      Tho I am running AIX 5.3 so I would check first via SMP notes.

      Mark

  • Mar 24, 2011 at 11:08 AM

    > We are having frequent issues where the memory is being consumed fully.

    What kind of "issues"? Linux always uses all available memory.

    > ***ERROR: /dev/shm is too small (19264 MB required, 8008 MB configured)

    what is you /etc/sysconfig/sapconf?

    > Processes........................: 897.9 MB

    > Extended Memory .................: 7788.0 MB

    > Extended Memory 2 ...............: 19264.0 MB

    > .. 70 VMs, 1048.0 MB address space

    Is VMC activated? (vmcj/activate =1)

    > -


    > Total, minimum requirement.......: 29958.4 MB

    So you configured the system to use 30 GB for ABAP.

    > Why is that we are running out of memory even though we have enough RAM to accomodate oracle and SAP and linux OS requirements?

    What error do you get and where do you get it?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Markus Doehr

      Hi Markus,

      You are simply too good.Thanks for the reply.

      Pasted below the output of mount command.

      /dev/mapper/sysvg-root on / type ext3 (rw)

      none on /proc type proc (rw)

      none on /sys type sysfs (rw)

      none on /dev/pts type devpts (rw,gid=5,mode=620)

      usbfs on /proc/bus/usb type usbfs (rw)

      tmpfs on /dev/vx type tmpfs (rw,size=4k,nr_inodes=2097152,mode=0755)

      /dev/sda1 on /boot type ext3 (rw)

      none on /dev/shm type tmpfs (rw)

      /dev/mapper/sysvg-home on /home type ext3 (rw)

      /dev/mapper/sysvg-opt on /opt type ext3 (rw)

      /dev/mapper/sysvg-var on /var type ext3 (rw)

      /dev/mapper/sysvg-crash on /var/crash type ext3 (rw)

      tmpfs on /tmp type tmpfs (rw,size=2g)

      /opt/local on /usr/local type none (rw,bind)

      /opt/openv on /usr/openv type none (rw,bind)

      /dev/vx/dsk/localdg/oracle on /oracle type vxfs (rw,delaylog,largefiles,ioerror= mwdisable)

      /dev/vx/dsk/localdg/pb0 on /oracle/PB0 type vxfs (rw,delaylog,largefiles,ioerror =mwdisable)

      /dev/vx/dsk/localdg/pb0sapreorg on /oracle/PB0/sapreorg type vxfs (rw,delaylog,l argefiles,ioerror=mwdisable)

      /dev/vx/dsk/localdg/saparchive on /saparchive type vxfs (rw,delaylog,largefiles, ioerror=mwdisable)

      /dev/vx/dsk/localdg/pb0_logAo on /oracle/PB0/origlogA type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

      /dev/vx/dsk/localdg/pb0_logBo on /oracle/PB0/origlogB type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

      /dev/vx/dsk/localdg/pb0_logAm on /oracle/PB0/mirrlogA type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

      /dev/vx/dsk/localdg/pb0_logBm on /oracle/PB0/mirrlogB type vxfs (rw,delaylog,lar gefiles,ioerror=mwdisable)

      /dev/vx/dsk/localdg/sapmnt on /sapmnt type vxfs (rw,delaylog,largefiles,ioerror= mwdisable)

      /dev/vx/dsk/localdg/usr_sap on /usr/sap type vxfs (rw,delaylog,largefiles,ioerro r=mwdisable)

      /dev/vx/dsk/sapsrmdg/pb0_data on /oracle/PB0/data type vxfs (rw,delaylog,largefi les,ioerror=mwdisable)

      /dev/vx/dsk/sapsrmdg/pb0_oraarch on /oracle/PB0/oraarch type vxfs (rw,delaylog,l argefiles,ioerror=mwdisable)

      none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)

      sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

      sapsepp:/interface on /interface type nfs (rw,soft,intr,addr=10.13.129.36)

      nfsd on /proc/fs/nfsd type nfsd (rw)