-
Increasing SGA size on Oracle 9i
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|