Re: Understanding the output from SHOW SGA

First off, The sizes are the max sizes allocated to Oracle. The sizes were determined by the parameters set in your init<sid>.ora file. Second, here are the difinitions of the Fixed and Variable Sizes: Fixed size is the space reserved for general database and instance information; no user data is stored there. Variable size is space for the shared pool, sort areas, and other user-related data.

Good Luck,
Satar Naghshineh
In article <3616edb2.5658061_at_netnews.worldnet.att.net>,   gennick_at_worldnet.att.net wrote:
> I'm trying to thoroughly understand the output from the SHOW
> SGA command. Here is what I get:
>
> SQL> SHOW SGA
> Total System Global Area 5508612 bytes
> Fixed Size 45584 bytes
> Variable Size 4529140 bytes
> Database Buffers 409600 bytes
> Redo Buffers 524288 bytes
>
> I'm having a bit of difficulty with the fixed vs variable
> size. Does "variable size" only applied to the shared pool
> portion of the SGA? Are the sizes of the database buffers
> and the redo buffers constant? Assuming that not all the
> variable size has been allocated, how do I tell what the
> _current_ size is?
>
> Jonathan
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 06 1998 - 12:43:46 CDT