Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SGA Info?
N Prabhakar <prabhs_at_po.pacific.net.sg> wrote:
>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,
>
>Fixed size is Operating system specific. You cannot tune the fixex size.
>It is something internal to Oracle.
>
>Variable portion of the SGA consists of arrays of variables which are assigned based on on init.ora parameters namely shared_pool, =
db_block_buffers, db_block_size, log_buffers etc. You can tune
>variable portion by adjusting the values of the above parameters
>Regards
>
>N.Prabhakar
>
>
Received on Sat Jan 18 1997 - 00:00:00 CST