| Advice on shared_pool and block_size on 9i [message #176087] |
Tue, 06 June 2006 20:54  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Dear All:
My understanding is that Oracle Kernel allocates memory to dictionary cache and Library Cache based on its own metrics. Is there a way, we can manipulate how much memory to be allocated to which cache in shared pool.
Another thing, I still consider that when we make the db_block_size=8k and build tablespaces, the block_size is not changable. It may be possible to make db_16K_CACHE_SIZE= or other ones but the default db_block_size that has been set in my case is 8K and not changeable. Am I right.
Any advice, suggestion, remarks will be appreciated and remembered with love and respect.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
