Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> [Q] db_block_size: 8K vs 2K default: Why is it better?

[Q] db_block_size: 8K vs 2K default: Why is it better?

From: Stephen Hurrell <hurrells_at_hotmail.com>
Date: Sun, 13 Feb 2000 16:30:42 -0500
Message-ID: <38A72282.D47EA434@hotmail.com>



OK.

Still looking for valid information about the db_block_size effect.

I have read various documents describing why you would adjust your block size from the default 2K.
These articles, books and personal opinions break down as follows:

I understand the relationship between larger block size results in fewer block reads from disk, shallower indexes and all sorts of OS performance improvements. Received on Sun Feb 13 2000 - 15:30:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US