Re: number of extents question

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3d80ede9_at_dnews.tpgi.com.au...
>
> "Paul Dixon" <paul.gp.dixon_at_bt.tinnedham.com> wrote in message
> news:alpv1p$7fu$1_at_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
>
> Hi Paul:
>
> I've learnt a valuable lesson from all this: once a piece of information
> goes onto the web, it never truly disappears! The material is available
 from
> lots of sites (one I know of is some kind of historical archive of the
> entire web, apparently -the mind boggles!!).
>
> But I can't tell you what any of them are, for which my sincere apologies.
>
> Other posters here may be more forthcoming.
>
> Regards
> HJR
>
>
>

I think I'll go and ogle the archives.

Paul Received on Sat Sep 14 2002 - 09:57:35 CDT