Re: DB_BLOCK_BUFFERS limit

Well on some Unix systems the max size of your SGA is related to two parameters SHMMAX (Maximum shared memory segment size) and SHMSEG (the maximum number of shared memory segments you may have per process) so give a SHMMAX of 2MB and SHMSEG of 10 the max SGA you could have would be 20MB. On some systems the limit on the size of the SGA is not related to these parameters, but to the SGA attachment address. Your SGA may need to be relocated. In version 6 the sgabeg is 0x2000000, in version 7 it is 0x3000000 and I am not sure what it is in ver 7.1. It maybe that the sgabeg is higher in ver 7.1 and therefore that is why it would fix the problem. Please note that the stuff mentioned here may not apply to AIX. But I encountered a problem similar to this on a Sun. Everytime I increased the DB_BLOCK_BUFFER beyond a certain point the database would not come up, it got some sort of error, unfortunately I do not remember the error just the reason for the error.

Mike H. Received on Tue Jul 11 1995 - 00:00:00 CEST