RE: ORACLE automatic update statistics better??
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2010 13:40:41 +0000
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.
Other related posts:
