Re: DB_BLOCK_BUFFERS under NT

Just as info:

The docs say max DB_BLOCK_BUFFERS is 3200 for NT.

DB ASSISTANT wont let you assign a size greater than 3200.

BUT... Just change the param in your init.ora file to any size you can handle and it will do fine (consider your machine, other apps and memory constraints of course...)

-Frank

In article <6utscv$8d$1_at_nnrp1.dejanews.com>,   hr784_at_cleveland.freenet.edu wrote:
> It will also depend on how much cache memory you have. Too high of a
> db_block_buffers setting coupled with your block size and shared pool size
> will bring your server to its knees.
>
> David Knollhoff
>
> In article <6ucp1k$s80$1_at_cbu.pvtnet.cz>,
> "Pavel Polcar" <pavel.polcar_at_berit.cz> wrote:
> > Hi,
> > Oracle8 Getting Started Release 8.0.4 for Windows NT (Appendix B) says it's
> > 3200 for Oracle8.
> >
> > Regards,
> > --
> > Pavel Polcar
> >
> > Greg Deuel wrote in message ...
> > >A basic question. Is there a limit to the number of db_block_buffers that
> > >can be assigned under NT 4.0 with either Oracle 7.3.x or 8.x?
> > >
> > >Thanks,
> > >
> > >- Greg
> > >
> > >Greg Deuel
> > >gdeuel_at_frxsoft.com
> > >
> > >
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 01 1998 - 07:57:54 CDT