Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Wed Sep 06 2000 - 14:43:05 CDT
![]() |
![]() |