Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: number of extents question
"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
Received on Thu Sep 12 2002 - 14:41:26 CDT