Re: SGA Info?

ptsao_at_sequeltech.com wrote:
>Can someone tell me how the follwoing fixed size and variable size
>info get calculated? What's their implication? Thank you.
>
>Phil Tsao
>
>SQL> select * from V$sga;
>
>
>NAME VALUE
>-------------------- ---------
>Fixed Size 34244
>Variable Size 7166208
>Database Buffers 1126400
>Redo Buffers 8192

Hi there,

Just a correction to my previous posting.

The size of the fixed portion of the SGA might change between different versions of the database. This size could also vary different UNIX platforms due to different alignment procedures. This is not tunable.

The variable size portion of the SGA consists of arrays of variables that are allocated based upon some INIT.ora parameters. Some of the parameters are

1. DB_BLOCK_SIZE
2. DB_BLOCK_BUFFERS
3. LOG_BUFFERS
4. SHARED_POOL_SIZE.