Re: init.ora changes
You have mentioned that db_block_buffers = 8192. But it seems that it should be a db_block_size.
Originally posted by cbarone
db_block_buffers = 8192
shared_pool_size = 52428800
large_pool_size = 70778880
java_pool_size = 20971520
Any recomendations in references to setting changes.
It would be more easy for me to suggest if you could provide the value of following parameters.
(4) no. of CPUs.
But , the size of the buffer_pool_keep depends on the size of the segments you want to place in the buffer cache for the life of the instance. these candicates are usually small tables.
Bufer_pool_recycle size depends on the size of the largest segment(s)which is accessed by FTS.
MS Computer Science
OCP DBA 9i/8i