Re: db block size, too big wasting buffer?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 24 Jun 2002 21:14:01 +0200
Message-ID: <uhf0kidb2do81f@corp.supernews.com>

"sg" <s4v4g3_at_europe.com> wrote in message news:3D175E5F.6090202_at_europe.com...
> Hi
>
> I am about to create a OLTP database of 16KB in 8.1.7, I have always
> read that dont make the db block size too big or we would be wasting
> data buffer. Is this true?
> Some say that db block size is another Oracle Myth, it does not really
> matter, is this a correct statement?
>

Fact: in an OLTP you read individual records mostly Fact: Oracle will always read a complete block.

Question: do you think a 16k block size will fit your OLTP scenario?

Also: please define 'some'? Hearsay? Knowledge?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Jun 24 2002 - 14:14:01 CDT