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: analyze estimate sample size

Re: analyze estimate sample size

From: Ari D Kaplan <akaplan_at_interaccess.com>
Date: Wed, 6 Sep 2000 14:43:05 -0500 (CDT)
Message-Id: <10611.116338@fatcity.com>


Ruth,

The ANALYZE_SCHEMA procedure is created by $ORACLE_HOME/rdbms/admin/dbmsutil.sql.

In it, there is documentation that indicates that you can pass the estimate_rows or the estimate_percent:

procedure analyze_schema(schema varchar2, method varchar2,   estimate_rows number default null,
  estimate_percent number default null, method_opt varchar2 default null);

--  Analyze all the tables, clusters and indexes in a schema.
--  Input arguments:
--    schema
--      Name of the schema.
--    method, estimate_rows, estimate_percent, method_opt
--      See the descriptions above in sql_ddl.analyze.object.
--  Exceptions:
--    ORA-20000: Insufficient privileges for some object in this schema.


So, it looks like you can provide the method (COMPUTE / ESTIMATE) and then the number of rows or percentage if desired.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

<-> For 380+ Oracle tips, visit:                         <->
<->                                                      <->
<->             www.arikaplan.com                        <->
<->                                                      <->
<->             email: akaplan_at_interaccess.com           <->

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

On Wed, 6 Sep 2000, Ruth Gramolini wrote:

> Hello all,
> 
> Can anyone tell me if you can change the sample size used when you analyze a
> schema with the 'estimate' option.  I would like to make it bigger.
> 
> Thanks in advance,
> Ruth B. Gramolini
> ORACLE & DB2  DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> rgramolini_at_tax.state.vt.us
> 
> -- 
> Author: Ruth Gramolini
>   INET: rgramolini_at_tax.state.vt.us
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 06 2000 - 14:43:05 CDT

Original text of this message

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