Home » Developer & Programmer » Warehouse Builder » SGA Size
SGA Size [message #93173] Fri, 30 May 2003 03:45 Go to next message
Velu Natararaj
Messages: 12
Registered: March 2003
Junior Member
Dear Guru's,

Can any one tell why my SGA size is too big. I have my parameter variable setting as follows:

SQL> SHOW SGA

Total System Global Area 839681796 bytes
Fixed Size 280324 bytes
Variable Size 687865856 bytes
Database Buffers 150994944 bytes
Redo Buffers 540672 bytes

init.ora
--------
shared_pool_size = 5242880
large_pool_size = 1048576
java_pool_size = 5242880
db_block_size = 8192
db_cache_size = 134217728
db_16k_cache_size = 16777216
log_buffer = 524288

i belive SGA size is calculated according to
SGA=DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE + DB_RECYCLE_CACHE_SIZE + DB_nk_CACHE_SIZE + SHARED_POOL_SIZE + LARGE_POOL_SIZE + JAVA_POOL_SIZE + LOG_BUFFERS + 1MB
Re: SGA Size [message #93259 is a reply to message #93173] Tue, 02 March 2004 11:19 Go to previous message
Peter Munro
Messages: 1
Registered: March 2004
Junior Member
The figures you have provided certainly don't add up to the total - you listed the main sga components, but there are others, as well.
Try 'select * from v$sgastat;' to find out where the memory is being allocated, in case you have still got this problem!
Previous Topic: sos
Next Topic: Oracle Warehouse Builder Trial : Urgent Help
Goto Forum:
  


Current Time: Thu Nov 20 17:33:36 CST 2014

Total time taken to generate the page: 0.10587 seconds