RE: Pre-seeding statistics with Interval Partitioning
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracledba71@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 5 Dec 2012 13:33:28 -0500
Stick in a dummy row to create the new intervals before you gather your
stats on the last Sunday of every month for the next month.
Or something like that.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of oracledba
Sent: Wednesday, December 05, 2012 12:16 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Pre-seeding statistics with Interval Partitioning
Hi All,
We scheduled to collect statistics on every Sunday. With Oracle10g we always
create partitions (range by date column) for the whole year up front.we
pre-seed statistics to a partition(using stats from its previous
partition) at the beginning of the month and the following weekend's stats
collection job would take care of the stats from there on.
Now with Oracle11g and with Interval Partitioning,how would i implement the
same?
Thanks
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
