Oracle DB_CACHE_SIZE

[Former Member]

Hi all,

Now i have upgraded the database in my SAP system(4.7) from 9.2.0.8 to 10.2.0.2.

I need to set the value of DB_CACHE_SIZE.

I have 8gigs of RAM and 32 bit enivironment and

SGA_MAX_SIZE is 1375731712 .

Please let me know what value to set.

Regards,

siddhartha.

[Former Member · Accepted solution]

Hi

Use the following command (Login as dba)

ALTER SYSTEM SET DB_CACHE_SIZE = <<size>>;

If you can shutdown the instance change size of DB_CASH_SIZE parameter and start the instance.

Check the following link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/0667b7c9-0e01-0010-e4a3-873e8765...

Regards

Bhaskar

[Former Member · Accepted solution]

A good starting value is to multiply your db_block_buffers with your block_size.

Example:

db_block_buffers = 10000

block_size = 8192

db_cache_size = 81920000

Dont forget to delete db_block_buffers from your (s)pfile after you have set db_cache_size