Re: number of extents question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 13 Sep 2002 11:28:12 +0100
Message-ID: <alsel9$6dh$2$8300dec7@news.demon.co.uk>

Actually I said I am happy with 20 to 50 extents. This is because if I had many more it would show that my sizing estimates were wrong.

I also said (and I think this is perhaps more important than an absolute number) that I like to see growing object allocate an extent every 2 to 4 weeks. The reason for this latter is that it makes it so much easier to predict future data volumes and to watch for anomalous behaviour.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______September 24/26, November 12/14

____USA__________November 7/9 (MI), 19/21 (TX)

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html








Yong Huang wrote in message ...


>"Richard Foote" <richard.foote_at_bigpond.com> wrote in message

 news:<x9wf9.29168$g9.83917_at_newsfeeds.bigpond.com>...


>> But would I rebuild a table if it had 10 or 20 or 100 extents. No.

>

>I agree. But I remember Jonathan Lewis seems to say if the number of

>extents exceeds 50 or 100, rebuilding the segment may be warranted. I

>don't have the book here so I may be misreading him.

>

>By the way, I never alter table/index coalesce, and I always use

>compress=n in export. I'd like to hear others' opinion.

>

>Yong Huang

Received on Fri Sep 13 2002 - 05:28:12 CDT