| SGA Size [message #93173] |
Fri, 30 May 2003 03:45  |
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  |
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
