RE: Forever running Analyze

[Christopher Spence]

if you cannot do the oracle "assessed estimate" of 3GB/hour then perhaps the IO system is in need of modification or replacement.

 

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 6:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Forever running Analyze

buy a better i/o subsystem?  this should finish in single digit minutes, at worst.

 

ok, can't do that?

 

then

 

tune the i/o system

can't?

ok, then partition the table/index to faster/more/different drives

can't?

ok, then run the analyze at night via cron

can't

ok, then screw it, it's not worth it.  ( just kidding )

-----Original Message-----
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 5: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