Re: gather stats

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 9 Nov 2015 10:12:31 -0700
Message-Id: <89E14C1C-4BCA-4763-B216-409AC0593A9D_at_centrexcc.com>

Use auto_sample_size and refrain from gathering histograms on all columns ( method_opt 'for all columns size 1')

Sent from my iPhone. Typing errors may have occurred.

> On Nov 9, 2015, at 10:01, K R <kp0773_at_gmail.com> wrote:
>
> All,
>
> What is the recommended way of gathering stats on 11gR2 database ( 2.5 TB) . If i keep estimate percent 10,15 then some of the table are taking hours and hours .
> Please let me know .
>
> Thanks in advance.
>
> Kart.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 09 2015 - 18:12:31 CET