RE: Pre-seeding statistics with Interval Partitioning

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 5 Dec 2012 13:33:28 -0500
Message-ID: <047001cdd317$05de84b0$119b8e10$_at_rsiz.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of oracledba
Sent: Wednesday, December 05, 2012 12:16 PM To: Oracle-L_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 05 2012 - 19:33:28 CET