Re: how do I increase cache size?

the parameter you need to change is in the init<sid>.ora file in the dbs directory. Parameter is db_block_buffers, the value is number of blocks.
low buffer cache misses does not necessarily mean that your buffer cache is to small. has the database been used long enough to get a good buffer?

Regards,
Richard Fuoco

On 7 Apr 1997 23:39:27 GMT, "Todd Marshall" <toddm_at_semaphore.com> wrote:

>
>I'm seeing 80% buffer cache misses, and need to know how to increase the
>memory allocated to the buffer cache. I've been through the DBA handbook
>and haven't seen any info on how this is done. Ya'll have any suggestions?
>
>-T
Received on Mon Apr 07 1997 - 00:00:00 CDT