avatar image
Former Member

Change Oracle Database "instance RAM" after the SAP import

Hi all

When I import a new SAP system the SWPM asks me for the "Database Instance RAM" and suggests me always the half available on the system. Check the picture below:

Is there a way to change this value(8GB in this case) in future when the SWPM is finished? I use Oracle 11.2.x and 12.1 with AIX 6.1 and 7.1

Thanks,
Marco

oracle-ram.jpg (49.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 30, 2017 at 03:24 PM

    Yes, you can change this value after the install. Please have a look to following notes:

    1431798 - Oracle 11.2.0: Database Parameter Settings

    789011 - FAQ: Oracle memory areas

    Best regards

    Bartosz

    Add comment
    10|10000 characters needed characters exceeded

    • Yes, you are correct. I though about DB_CACHE_SIZE, but in your config file this has a different value. Unfortunately, I don't have access to any Oracle DB server to check the value of this parameter. But this is definitely the place where I'd start my investigation.

      Best regards

      Bartosz

  • Jun 07, 2017 at 01:59 PM

    The amount of memory you have allocated is not necessarily for one database parameter. The value you specify there under instance RAM is then shared for parameters like SGA, PGA, etc. Once the import has been completed you may modify the Oracle parameters according to your needs. The db_block_size parameter is for the size of the Oracle data blocks and DB_CACHE_SIZE alone is not going to take 8GB. It comes under SGA along with other initialization parameters. Check the SAP note 789011 - FAQ: Oracle memory areas and also read the Oracle documentation about Memory Architecture.

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content