fake stats to a particular partition

  • From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
  • To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Aug 2006 20:14:24 +0300

Hello List,

Is there any way that we can set fake statistics to a particular
partiton of a partitioned table?
As I had asked a question sometime back that insert and other stuff
are very slow on the first day of a new partition(monthly partitions).
I would like to set fake statitics to a partition of a partition table.

Thanks for your time.

Jaffar
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
Banque Saudi Fransi,
Saudi Arabia

I blog at :http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l


Other related posts: