Re: ORACLE automatic update statistics better??
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Wed, 18 Aug 2010 14:57:39 -0600
Message-ID: <AANLkTiks9ZZDetMrYXGnfHUR=eOGQ7uB3DSYAdAdY5AO_at_mail.gmail.com>
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.
Date: Wed, 18 Aug 2010 14:57:39 -0600
Message-ID: <AANLkTiks9ZZDetMrYXGnfHUR=eOGQ7uB3DSYAdAdY5AO_at_mail.gmail.com>
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 18 2010 - 15:57:39 CDT