Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> fake stats to a particular partition

fake stats to a particular partition

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Thu, 10 Aug 2006 20:14:24 +0300
Message-ID: <97b7fd2f0608101014l5c01ddcbje308f82022de1fb7@mail.gmail.com>


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."
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 10 2006 - 12:14:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US