Re: Very slow metadata-only expdp
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 23 Oct 2016 13:13:07 -0400
Message-ID: <1e78057a-1f90-06dd-e41a-9999c57b70c9_at_gmail.com>
Date: Sun, 23 Oct 2016 13:13:07 -0400
Message-ID: <1e78057a-1f90-06dd-e41a-9999c57b70c9_at_gmail.com>
Or, use SAMPLE=0.25. That should estimate statistics, based on the sample of 0.25% of the table data. The old and deprecated "exp" utility had an argument which enabled it to skip the statistics collection altogether.
On 10/23/2016 03:09 AM, Martin Berger wrote:
> Deepak,
>
> based on this answer, did you try ESTIMATE=STATISTICS?
> This should not try to "count blocks" for the estimates (and they are
> of no interest at all).
>
> Martin
>
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 23 2016 - 19:13:07 CEST