At current setting, the memory for db_buffer_cache is 90000* block_size, If
your db_block_size = 2K
then, the memory for db_buffer_cache is 180 MB already. You may do not have
enough physical memory
to support higher setting. OS, shared_pool, and user process may all need
some memory.
mohdzaid <mohdzaid_at_pacific.net.sg> wrote in article
<6omv2v$buf$1_at_newton2.pacific.net.sg>...
> Hi,
>
> Currently I have db_block_buffer=90000. I have shared_pool_size=35000000.
> Total memory usage for Oracle is 253MB. I wanted to set a higher
> db_block_buffers of 25% of Total memory which is approx=64MB but I was
> unable to startup my oracle database after that. The highest value I can
set
> for my db_block_buffer is 90000 anything beyong that will disable me to
> startup. Appreciate if anyone could give me advise. Thank you.
>
>
> Best Regards,
> Zaid
> Siemens Medical Instruments Pte Ltd.
> Reply to zaid.lazim_at_smi.siemens.com.sg
>
>
>
Received on Fri Jul 17 1998 - 16:18:46 CDT
