Re: Is Oracle deliberately difficult?

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Fri, 01 Sep 2000 03:53:10 GMT
Message-ID: <20000901.3531000@mis.configured.host>

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<


		{snip}


> >>

> >> 2) Space management
> >> Oracle makes you do too much work with worrying about extents, bloc
 k
> >> sizes, etc. You can justify some of it by saying you can tweak you
 r
> >> performance, but not for what the effort seems to be.
> >>
> >
> >I don't know about effort. But then I take a cavalier approach to th
 ese
> >things: I aim for one giant extent per segment, and am happy to rest

content
> >with all that space sitting there empty for most of the time, knowing
 

that
> >it will be used eventually. Hard disks are cheap, and I'd throw more
 

hard
> >disks at the problem rather than worry about extent management. All

extents
> >within a given tablespace should be the same size anyway, and 8i's lo
 cal
> >management of tablespace makes that a painless task these days.
> >
> >And there's really no debate about block size these days (despite wha
t
some
> >people would have you believe). For most Unixes it's 8Kb without
 thinking,
> >and same for NT. www.ixora.com.au has the details.
> >
> In the previous reply, Jerry Gitomer wrote:
> Block sizes are set when you create a database. The big issue is
> whether or not to go with the maximum block size Oracle supports. The
 

> general consensus is that for most databases you should go as big as
> Oracle will support.
 

> So, we've got 2 Oracle experts, 1 says 'no debate- 8K' and 1 says 'max
 

> that Oracle supports'. This is easy? Right?

        At the moment 8KB IS the maximum block size that Oracle supports on mos t
platforms so there is no disagreement and it really is easy.

>
> Jay M. Scheiner
> Programmer/Analyst
> Wolpoff & Abramson, LLP
> remove nospm from email address
> Opinions are my own only!
Received on Thu Aug 31 2000 - 22:53:10 CDT