Gurus
I want to set my buffer cache size to about 100M, or 150M or 200M. My block size is 8192bytes, how do I calculate my db_block_buffers parameter??? Please provide details.
Thanks in advance!
Printable View
Gurus
I want to set my buffer cache size to about 100M, or 150M or 200M. My block size is 8192bytes, how do I calculate my db_block_buffers parameter??? Please provide details.
Thanks in advance!
eh??? what do you mean how to calculate?
db_buffer_cache_size / db_block_size = round(db_block_buffers)
Jr.
sorry I thoguht it was more advanced question... :(
JR,
I might be wrong but do this db_buffer_cache_size known as any other thing in ORACLE 8???