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 -> Re: Oracle block size - OS block size

Re: Oracle block size - OS block size

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Sun, 17 Jun 2001 15:28:59 GMT
Message-ID: <3b2ccc2b.259786015@news.alt.net>

On Mon, 18 Jun 2001 00:42:39 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

>Probably.
>
>Not doubting your maths, nor your accuracy... but until we get to talking
>about multi-Gigs, the point is sound, and I prefer your more rigorous
>examination of the issues to my feeble attempts.... the net result remains,
>the amount of space wasted by going for the larger block size is not
>significant, compared with the relevant performance benefits.
>
>Cheers,
>HJR
Heh. I am in middle of reading this material because we're going to create some new tablespaces and move some tables around. We're using 8k block size and I am not worried about the tens of small lookup tables that'll waste space. Even at a gig, I agree, it means little in the overall picture. I was just trying to see if I my understanding was correct.

Brian Received on Sun Jun 17 2001 - 10:28:59 CDT

Original text of this message

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