Increasing SGA size on Oracle 9i
I have installed Oracle 9i and as a default SGA is created as 121 MB.
I have 4 GB RAM on the Server and trying to increase the size of SGA, but getting an error not enough memory available to increase the SGA.
Any help will be apprecaited.
If this is UNIX, Check for SWAP Area...
Is this the only Version of ORacle on that Box ?
This a NT box with NT 4 sevice pack 6 on it.
I have got some info looking at the documentation on Oracle Site.
The total number of bytes of database buffers (that is, DB_BLOCK_BUFFERS multiplied by DB_BLOCK_SIZE) is no longer limited to 3 GB.
Dynamic System Global Area (SGA) and multiple block size are not supported with VLM. When VLM is enabled, the following new buffer cache parameters are not supported.
To select the block size for the instance, use the initialization parameter DB_BLOCK_SIZE. The buffer cache size is set by the initialization parameter DB_BLOCK_BUFFERS.
1. What is VLM ? and how can I disable it ?
2. I wanted to use DB_CACHE_SIZE to utilize the DB_32K_CACHE_SIZE as I was told it could improve the performance when reading large tables.
Click Here to Expand Forum to Full Width