Re: gather stats

  • From: Moizuddin Arshad Mohamed <moizarshad@xxxxxxxxx>
  • To: breitliw@xxxxxxxxxxxxx
  • Date: Mon, 9 Nov 2015 11:37:59 -0600

Hi Kart,

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@xxxxxxxxx* <moizarshad@xxxxxxxxx>

On Mon, Nov 9, 2015 at 11:12 AM, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
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@xxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l



Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2015