Re: gather stats

I agree with Wolfgang to use auto_sample_size and not to collect histogram, especially for the OLTP system.

*Thanks,*
*Moizuddin A Mohamed*
*Sr Oracle DBA*
*Cell: (517) 515 9900*
*moizarshad_at_gmail.com* <moizarshad_at_gmail.com>

On Mon, Nov 9, 2015 at 11:12 AM, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:

> 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
>
>
>

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