I am hoping that things might work. This is one of our posibilities
tonite. I have just always stayed clear of Estimating statistics. But,
thanks for the numbers. I will consider it.
Kevin
-----Original Message-----
Sent: Tuesday, June 12, 2001 4:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Hi Kevin,
I use estimate stats with sample 30 percent with some of the large tables
(~ 60,000,000 rows). Generated stats are okay. It completes in about 2-3
hours (8.0.6 and 8.1.7 databases).
Have you considered estimating stats rather than computing?
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -----Original Message-----
> From: Kevin Lange [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Forever running Analyze
>
> Hi folks;
> We have an Analyze running that is taking forever. Here is the setup:
> The table is about 250 bytes wide.
> The table is normally 100,000 rows
> The table has grown to over 4,000,000 rows.
> There is one index on 1 column.
> We used the Compute Statistics options
>
> Does anyone have any suggestions on how we can get this analyze to
> complete and still generate worthwile statistics ??
>
> Thanks
>
> Kevin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).