Increasing SGA size on Oracle 9i

[Sam255]

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.

[vr76413]

If this is UNIX, Check for SWAP Area...

Is this the only Version of ORacle on that Box ?

Ron

[Sam255]

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,