Re: DB_BLOCK_BUFFERS * DB_BLOCK_SIZE

I wouldn't see any problem with that just make sure you don't get into any swapping with that.

Daniel Murray

SDC wrote:

> Sun Solaris E4000 (Solaris 2.6) w/ 1.5gb RAM
> Oracle 8.0.5
>
> DB_BLOCK_SIZE: 8192 (8K)
> DB_BLOCK_BUFFERS: 100000
> Question:
>
> If this machine is dedicated to Oracle, why wouldn't I want to set the above
> parameters which would allocate around 800mb for SGA? The previous setting
> was 5,500 block buffers which works out to 44MB and the system was pitifully
> slow...
Received on Mon Jun 28 1999 - 10:20:37 CDT