Solved

SGA.. fixed size and variable size

Posted on 2006-10-24
3
2,788 Views
Last Modified: 2007-12-19
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.

0
Comment
Question by:mohammadzahid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 11

Author Comment

by:mohammadzahid
ID: 17799407
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
0
 
LVL 8

Accepted Solution

by:
Pierrick LOUBIER earned 500 total points
ID: 17800024
Have a look at this excellent article written by guru Tom Kyte : http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:365088445659
0
 
LVL 11

Author Comment

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

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question