Home » RDBMS Server » Server Administration » Problem in SGA Size
Problem in SGA Size [message #57237] Fri, 30 May 2003 03:58
Velu Natarajan
Messages: 16
Registered: July 2002
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

shared_servers = 3

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

Regards,

Velu N

Report message to a moderator

Previous Topic: Can't connect to Oracle Databases after domain change
Next Topic: tablespace management
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 30 17:32:32 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.