Skip to Content
avatar image
Former Member

Recommended value for pga_aggregate_target

Hi

What should be the pga_aggregate_target value in R/3 ECC 6 system, Oracle 12C

As per oracle document, 20 % of SGA and Note 1888485 says 20% of available memory.

We have CI instance with total 20 GB allocated and SGA size is 4 GB.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 24, 2017 at 12:22 AM

    hi,

    this depends on you how much memory you intend for oracle, then give 20 % of the available memory.

    Since you have ci installed in the same host of db server, in this case, you can order an sap service for the sizing tuning. The service will probably guide you how much memory for ci, sga, pga, etc.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2017 at 10:43 AM

    Hi James

    I have RAM 20 GB on that virtual machine and SGA 4 GB then please suggest 20 % of what Total RAM or SGA.

    regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member James Zhang

      Hi,

      I don't agree with James suggestion, normally we will give 30% of all available RAM to Oracle database instance, in this case it's a single host installation. We leave 5%-10% for OS resources.

      If we leave 10% for OS, for Oracle instance it will be 20*90%*30% = 5.4GB, so SGA will be 20% of 5.4GB

      Regards,

      Michael

  • avatar image
    Former Member
    Mar 24, 2017 at 07:31 PM

    Hi,

    Are you facing any issue on your system OR did you observe anything in control file/trace ?

    Refer below links to understand pga_aggregate_target better, it is outside SGA and system uses it for extensive operations.

    http://gerardnico.com/wiki/database/oracle/pga_aggregate_target

    https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams157.htm#REFRN10165

    I would take a look at memory distribution on server and take actions at specific layer (Only if I face any memory issues/alerts).

    You have 20GB on DB+CI server so first check how much memory is allocated to Database, what is the allocation to CI and how much is being used, what is left for OS......then tune memory parameters based on usage.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded