Considering manually generating statistics for these tables using a sample size then locking the statistics so the Oracle provided job does not regenerate statistics for these tables. You can write a script that unlocks the statistics, re-calculates the statistics, and relocks the statistics using parameters you have determined work better for these specific tables. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandra Becker Sent: Wednesday, August 18, 2010 4:58 PM To: oracle-l Subject: Re: ORACLE automatic update statistics better?? We ran into problems with the auto stats job on a few of our large tables that can grow by 10 percent of more in a day or two. It takes several hours to get the stats on the largest table and caused significant performance problems for our customers. -- Sandy Transzap, Inc.