Re: DB_BLOCK_BUFFERS under NT

I can't find any references to a limit on this value. I have 4 NT servers, each with 1GB RAM and I have DB_BLOCK_BUFFERS set to 64,000 on each of them (with 8K blocks that's 500MB of buffer space). My experience is with 7.3.3 Enterprise on NT, not 8.0.

I checked the "Getting Started" manual that Pavel referenced below, but the 7.3.3 version rather than 8.0.4 and it does not indicate a limit on DB_BLOCK_BUFFERS. It does give as an example a "large" SGA with 3200 buffers.

nasof_at_hotmail.com wrote in message <6uvu8i$alg$1_at_nnrp1.dejanews.com>...
>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 - 14:04:04 CDT