Re: Large initial extent after import

From: Jens Schauder <Jens.Schauder_at_opal-edv.com>
Date: Fri, 13 Nov 1998 07:27:10 GMT
Message-ID: <01be0ed7$058f7dc0$186fe491@wntsca36>

Jan Dolman <pantah_at_commonsense.speed.a2000.nl> wrote in article <364b52d3.360440_at_news.a2000.nl>...
> When importing an export file that was exported using COMPRESS=Y,
> Oracle creates an inital extent for each table large enough to hold
> the entire table. For some tables, this initial extent can be quite
> big.
> Questions:
> Is there a good reason to want this large extent?

Yes because its the optimal for performance to have one extent instead of a lot of small ones

> Is there a good reason NOT to want this large extent?
I don't think so (see above)

>
> Let me know what I want
>
> Jan
>
> pantah_at_commonsense.speed.a2000.nl
> (remove "commonsense." when replying)
>
>
Received on Fri Nov 13 1998 - 01:27:10 CST