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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle manual : Greater O/S block size......

RE: Oracle manual : Greater O/S block size......

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 12 Jul 2000 09:10:21 -0300
Message-Id: <10556.111784@fatcity.com>

	The more
	GENERAL rule of thumb is that your Oracle block size should be a
multiple
	of your OS block size, so with Veritas defaults, a multiple of 8k,
so 8k,
	16k, 32k...

Ah, but should it be 8K or 32K?

Smaller blocks have a little more overhead, because they each have a = data
block header.

But then the OS had to load more data into memory every time a block is read.

If the rows are small then 8K is fine, if the rows are large then would = 32K
be better.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

Ph: (902) 426-4774

	-----Original Message-----
	From:	sean.hull_at_pobox.com [SMTP:sean.hull_at_pobox.com]
	Sent:	Wednesday, July 12, 2000 6:10 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: Oracle manual : Greater O/S block size......


	On Tue, 11 Jul 2000, Gurgaon, DBA (CAP, GECSI, CONTRACTOR) wrote:


> Oracle says "DB block size should be greater than OS block size
> for better performance of your database".
This is a rule of thumb based probably on older filesystems. The more GENERAL rule of thumb is that your Oracle block size should be a multiple of your OS block size, so with Veritas defaults, a multiple of 8k,
Received on Wed Jul 12 2000 - 07:10:21 CDT

Original text of this message

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