Re: fixed size and variable size

Hi,

the fixed sga size only contains general informations for the background processes as i.e. state of the database and instance. There is no user data stored. Therefore it's often smaller than 100 K.

The variable size of the sga consists of these init.ora parameters:  shared_pool_size
large_pool_size
+ version specific parameters:

you can calculate the approx. sga-size with the following formulas:

8.0.x  

    ((db_block_buffers * block size) +
    (shared_pool_size + large_pool_size + log_buffers) + 1MB  

8.1.x

    ((db_block_buffers * block size) +
    (shared_pool_size + large_pool_size + java_pool_size + log_buffers) + 1MB

9.x

  db_cache_size + db_keep_cache_size + db_recycle_cache_size + db_nk_cache_size
  + shared_pool_size + larg_pool_size + java_pool_size + log_buffers + 1MB

Best regards
Dirk Drexler

"WK Yeoh" <cwy006_at_motorola.com> wrote in message news:<a1tios$u$1_at_newshost.mot.com>...
> Hi,
>
> Anyone can help to explain what is the meaning of fixed size and varaible
> size showed when issuing the "show sga" command in the server manager?
>
> Rgds,
> Wk
Received on Mon Jan 14 2002 - 08:03:59 CST