Allocates shared memory to the database cache to create global buffers.
Six comma-separated values specify how many megabytes of shared memory to allocate for different sizes of global cache. From left to right, each value is the number of megabytes for global caches organized into:
no longer used, always 0
So, for example, the following setting:
Allocates 16 megabytes of buffers for 8–kilobyte database blocks.
Allocate 8mb of 4kb blocks and 32 mb of 8kb blocks:
Allocate 32 mb of 8kb blocks. If a need for a 4kb block exists, then the system uses an 8kb block to store it since no 4kb blocks are configured:
Let the system allocate memory itself by setting all parameters to 0.
Range of Values
If all the values are 0, space is automatically allocated based on an estimate of the machine capability and shared memory resources. On a 64–bit system, there is a limit of 16 TB.
On the page System Administration > Configuration > System Configuration > Memory and Startup, select the option to Configure Memory Settings Manually. Enter number of megabytes for the amount of memory to allocate for each database block size.