Increasing SGA size on Oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Increasing SGA size on Oracle 9i

  1. #1
    Join Date
    Apr 2003
    Location
    Canada
    Posts
    2

    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.

  2. #2
    Join Date
    Oct 2002
    Posts
    284
    If this is UNIX, Check for SWAP Area...

    Is this the only Version of ORacle on that Box ?

    Ron

  3. #3
    Join Date
    Apr 2003
    Location
    Canada
    Posts
    2
    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
  •  


Click Here to Expand Forum to Full Width