For any 64-bit
platform:
100 through 231-1 (Might be less on some 64 -bit platforms due to operating-system
limitations)
BUFFERS specifies the maximum number of shared-memory buffers that the database server user threads have available for disk I/O on behalf of client applications. Therefore, the number of buffers that the database server requires depends on the applications. For example, if the database server accesses 15 percent of the application data 90 percent of the time, you need to allocate enough buffers to hold that 15 percent.
In general, buffer space should range from 20 to 25 percent of physical memory. It is recommended that you calculate all other shared-memory parameters after you set buffer space (BUFFERS * system page size) to 20 percent of physical memory.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]