OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » SGA size (10g R1,Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SGA size [message #283609]

Tue, 27 November 2007 12:45

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