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'
Everything Changes
2 weeks ago
No comments:
Post a Comment