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: number of extents question

Re: number of extents question

From: Paul Dixon <paul.gp.dixon_at_bt.tinnedham.com>
Date: Thu, 12 Sep 2002 12:44:29 +0100
Message-ID: <alpv1p$7fu$1@pheidippides.axion.bt.co.uk>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3d805179_at_dnews.tpgi.com.au...
> Gawd! What a lot of work. And for no good reason, too! I suppose there's a
> reason you haven't switched to Locally Managed Tablespace, where all this
> kerfuffle would be completely unnecessary?
>
> >compress=n makes sense for uniform extent sizes ...
>
> Compress=n makes sense in just about every situation I can imagine. There
> are NO good reasons why a segment should comprise just one extent.
> ...................

Howard,

the 'Co-Operative FAQ' refers to a couple of documents you have written on this topic. I understand the website they were hosted on is now closed. Are they available anywhere else ?

regards

Paul Dixon Received on Thu Sep 12 2002 - 06:44:29 CDT

Original text of this message

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