Re: SGA Info?

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/01/17
Message-ID: <5bp1pi$pau@newton.pacific.net.sg>#1/1

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 size on init.ora parameters namely shared_pool etc. You can tune variable size by modifying the initialization parameters.

Regards

N.Prabhakar Received on Fri Jan 17 1997 - 00:00:00 CST