<div>
Sorry, here is the output of the V$SGA from my local XP system. Values represented are default values of Oracle when created/installed. <br />
<br />
<br />
<br />
SQL&gt; select * from V$sga;<br />
<br />
NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUE<br />
-------------------- ---------<br />
Fixed Size &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;454644<br />
Variable Size &nbsp; &nbsp; &nbsp; &nbsp;109051904<br />
Database Buffers &nbsp; &nbsp; &nbsp;25165824<br />
Redo Buffers &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;667648<br />
<br />
total SGA size &nbsp;SQL&gt; select sum(bytes) from V$sgastat;<br />
<br />
SUM(BYTES)<br />
----------<br />
&nbsp;135328756
</div>


Sorry, here is the output of the V$SGA from my local XP system. Values represented are default values of Oracle when created/installed.



SQL> select * from V$sga;

NAME                     VALUE
-------------------- ---------
Fixed Size              454644
Variable Size        109051904
Database Buffers      25165824
Redo Buffers            667648

total SGA size  SQL> select sum(bytes) from V$sgastat;

SUM(BYTES)
----------
 135328756

<div>
Thanks for forwarding a great link. This link answered all my questions. There is a reason Tom Kyte is an Oracle guru. :-)
</div>


Thanks for forwarding a great link. This link answered all my questions. There is a reason Tom Kyte is an Oracle guru. :-)

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
I am trying to understand how Oracle uses memory structure for tuning purpose. &nbsp;For that I ran a simple select against V$sga and like to know:<br />
<br />
- What is the fixed size? <br />
- What is the variable size? &nbsp; <br />
<br />
&nbsp;area in the SGA. <br />
<br />
How are these two areas in the SGA calculated? And, what is there use? <br />
<br />
Thanks.<br />
<br />

</div>
</div>


Hello, 

I am trying to understand how Oracle uses memory structure for tuning purpose.  For that I ran a simple select against V$sga and like to know:

- What is the fixed size? 
- What is the variable size?   

 area in the SGA. 

How are these two areas in the SGA calculated? And, what is there use? 

Thanks.



SGA.. fixed size and variable size

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.