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: Unix Block Size

RE: Unix Block Size

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Fri, 4 Aug 2000 11:37:48 +0300
Message-Id: <10579.113823@fatcity.com>


Rajesh,

Oracle Block size should be multiple of Operating system block size. So you cannot create Oracle Block size of 2K/4K, while your Operating system block is 8K.

HTH, Sandeep.
Riyadh, Saudi Arabia.

-----Original Message-----

	From:	Rajesh Dayal [SMTP:Rajesh_at_ohitelecom.com]
	Sent:	Thursday, August 03, 2000 7:43 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: Unix Block Size

	Now I have confirmed it from One of the Unix Gurus that the 
	default Unix Block size of DEC Unix is 8K (which is the case
	right now). One can check it using command 

	disklabel /dev/rrz9c

	But what about the Oracle Block size? Should I go
	for 8k or not? As I said the Maximum Row length of application's
	biggest table is not more than 400. Please advice.
		What could be the disadvantages if I still choose 2k/4k ?

	Thanks,
	Rajesh


-----Original Message-----
Sent: Wednesday, August 02, 2000 2:47 PM To: 'ORACLE-L_at_fatcity.com' Hi All, I know this might have been discussed several times...... But still I would appreciate if some-one could tell me how to check the current Block size in Unix File System. I am on Digital Unix 4.0 D with UFS. I guess that the current Unix Block Size is 8K, but Oracle Block size is set to 2K, what are the disadvantages of this (there could rarely be any advantage)?? It's an old installation and I have a chance to rectify the (error in) block size (upgrading from 7.3.4 to 8.1.5). But the maxm avg_row_len is less than 400. Any other specific issues/concerns you would like to forewarn me ??? Appreciate all your replies, Greets, Rajesh -- Author: Rajesh Dayal INET: Rajesh_at_ohitelecom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Fri Aug 04 2000 - 03:37:48 CDT

Original text of this message

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