Re: sga size

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/10/28
Message-ID: <718odp$fuu@dfw-ixnews6.ix.netcom.com>#1/1

you will see more detailed distinction of the SGA by querying the v$sqlarea. Winnie

Paul Chang wrote in message <715kve$b9e$1_at_ebaynews1.Ebay.Sun.COM>...
>
>Hi,
>
>I got the following output after I restartup my oracle server.
>
>Total System Global Area 4762032 bytes
>Fixed Size 39816 bytes
>Variable Size 4304424 bytes
>Database Buffers 409600 bytes
>Redo Buffers 8192 bytes
>
>can somebody explain
>what is Fixed Size? and Variable Size?
>how their number comes out 39816?4304424? by adding up other number?
>
>thanks,
>
>Paul.
>
>
>
Received on Wed Oct 28 1998 - 00:00:00 CST