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

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

Re: fake stats to a particular partition

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 10 Aug 2006 10:36:51 -0700
Message-ID: <1155231410.44db6eb3031dd@webmail.hosting.telus.net>


Yes, have a look at the procedures available in the dbms_stats package.

Quoting Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>:

> Is there any way that we can set fake statistics to a particular
> partiton of a partitioned table?

> I would like to set fake statitics to a partition of a partition table.
>
> Thanks for your time.
>

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 10 2006 - 12:36:51 CDT

Original text of this message

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