Home » RDBMS Server » Performance Tuning » SGA size (10g R1,Windows XP)
SGA size [message #283609] Tue, 27 November 2007 12:45 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I am trying to udnerstand the SGA memory distribution amound diff memory structures .

SQL> show sga

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145750508 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
SQL> show parameter shared_pool

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
shared_pool_reserved_size            big integer 4M
shared_pool_size                     big integer 48M
SQL> show parameter db_cache

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
db_cache_advice                      string      ON
db_cache_size                        big integer 24M
SQL> show parameter log_buffer

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
log_buffer                           integer     262144


Total SGA is 171 M but adding sharedPool+DB_CACHE+LOG_BUFFER coemes only around 72M .

Can someone tell me hw these calcuations are made

[Updated on: Tue, 27 November 2007 12:48]

Report message to a moderator

Re: SGA size [message #283610 is a reply to message #283609] Tue, 27 November 2007 12:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter sga

Regards
Michel
Re: SGA size [message #283611 is a reply to message #283609] Tue, 27 November 2007 12:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Concepts
Chapter 8 Memory Architecture

Regards
Michel
Re: SGA size [message #283613 is a reply to message #283609] Tue, 27 November 2007 12:55 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/218728/42800/?srch=show+sga#msg_218728
Previous Topic: tunning notes
Next Topic: Snap Shot Error on User_Tables
Goto Forum:
  


Current Time: Thu Dec 08 00:17:29 CST 2016

Total time taken to generate the page: 0.06920 seconds