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,