RE: Forever running Analyze

From: Kevin Lange <kgel_at_ppoone.com>
Date: Tue, 12 Jun 2001 14:43:48 -0700
Message-ID: <F001.00326968.20010612143911@fatcity.com>

New
file system is out. We are running on Net App Appliances containing a Raid 5 system on Solaris using Oracle 8.0.5. Not the best environment but its what we have to work with. So, hardware is out.

As far
as file system tuning ..... Another no. Its a Waffle system ..... basicly, write anywhere , so where you put the tables and indexes are prety much a moot point.

So, we
are down to runnig it at night. Not the kind of suggestion I was looking for .... but its the one I figured I would hear. 
Oh
well.

Thanks
anyway.

-----Original Message-----From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]Sent: Tuesday, June 12, 2001 5:05 PMTo: Multiple recipients of list ORACLE-LSubject: 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:kgel_at_ppoone.com]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: 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 Received on Tue Jun 12 2001 - 16:43:48 CDT