RE: Unix Block Size

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).