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: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 7 Sep 2000 08:03:10 -0400
Message-Id: <10612.116395@fatcity.com>


Thanks, Ari! RBG
----- Original Message -----
From: Ari D Kaplan <akaplan_at_interaccess.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 06, 2000 4:54 PM Subject: Re: analyze estimate sample size

> 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).
> >
>
> --
> Author: Ari D Kaplan
> INET: akaplan_at_interaccess.com
>
> 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
Received on Thu Sep 07 2000 - 07:03:10 CDT

Original text of this message

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