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.