Re: analyze estimate sample size

Ruth,

I am not sure if you are using dbms_utlity or not. But, if you analyze a table through SQL*PLUS you can increase the sample size. I am pretty sure you can do this through dbms_utlity.

Example:

analyze table xxxxxx estimate statistics sample 50 percent;

Sandy Druar
Oracle DBA
sdruar_at_eckerd.com

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 - 18:07:10 CDT