Re: unable to set higher db_block_buffers

What is your block size? At 2K, and db_block_buffers=90000, your buffers would use up 90000*2048 which equals 184M !

Also, do you realize that you are giving EACH user 35M of memory for shared_pool each time they log on? This is not total shared pool for ALL users, it is PER user.

-Frank

In article <6omv2v$buf$1_at_newton2.pacific.net.sg>,   "mohdzaid" <mohdzaid_at_pacific.net.sg> wrote:
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 17 1998 - 00:00:00 CDT