Hi Guys,
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.
Printable View
Hi Guys,
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 ?
Ron
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.
DB_CACHE_SIZE
DB_2K_CACHE_SIZE
DB_4K_CACHE_SIZE
DB_8K_CACHE_SIZE
DB_16K_CACHE_SIZE
DB_32K_CACHE_SIZE
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.
Rgds,
