Skip to Content
avatar image
Former Member

memory issue

Hi,

Tuning:

em/initial_size_mb =32768

em/max_size_mb=4092

PHYS_MEMSIZE=64

RAM size is 210 GB.the RAM utilization is never reached more than 60% .how to utilize or tune my

DB parameters so that it will use max RAM.

Also we are getting frequently lock table overflow .

enque/table_size =281600 in app server1 and 4096 in app server2.

Please suggest.

Regards,

ARNS.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 17, 2009 at 10:06 AM

    many lock entries found RISENQ and EQUI tables only.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2009 at 05:45 AM

    Hello,

    Are you facing any performance problems?

    Are you having any additional instance running on the same box?

    suggest you reading the following for memory;

    http://help.sap.com/saphelp_erp2004/helpdata/en/02/96253c538111d1891b0000e8322f96/frameset.htm

    For the lock overflow:

    Is the error specific to one app server.If yes, consider changing the parameter enqueu_table size.

    Thanks,

    Prasanna

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2009 at 08:44 PM

    > em/initial_size_mb =32768

    > em/max_size_mb=4092

    > PHYS_MEMSIZE=64

    >

    > RAM size is 210 GB.the RAM utilization is never reached more than 60% .how to utilize or tune my

    > DB parameters so that it will use max RAM.

    What OS are you using?

    What database are you using? The above parameters are no database parameters but SAP parameters...

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi,

      so has this problem any solution? we have the same issue with MIGO and i dont know, i can increase the max size in parameter ENQUE/TABLE_SIZE...

      thx

      pj