Friday, September 11, 2009

SGA SIZE CALCULATION

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


SELECT SUM (VALUE) / (1024)
FROM v$parameter
WHERE NAME IN
('db_16k_cache_size',
'db_2k_cache_size',
'db_32k_cache_size',
'db_4k_cache_size',
'db_8k_cache_size',
'db_cache_size',
'db_keep_cache_size',
'db_recycle_cache_size',
'java_pool_size',
'large_pool_size',
'shared_pool_size',
'log_buffer',
'db_block_buffers',
'db_cache_size'
) --+ 1MB


select *---value
from v$parameter
where name ='large_pool_size'

No comments: