RE: Forever running Analyze

Waffle file system goes by the theory of writing anywhere it pleases, it also will not modify blocks directly unless there are no blocks available. Saving them for doing snapshots and quick recovery.

NetApp uses Raid 5 pretty religiously, but has a write-back NVRAM that is placed very early in the transaction process to speed response time. If I remember correctly it does not support Pre-fetch or any of the nicer EMC features as such as that.

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

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
Sent: Tuesday, June 12, 2001 7:11 PM
To: Multiple recipients of list ORACLE-L

Kevin,
 

I thought that those are actually RAID 4. You don't have any control over allocation on a NetApp box? Is that due to inherent limitations of the volume manager/file systems or due to implementation specific to your SysAdmins' biases?
 

thanks,
 

Paul
 

-----Original Message-----
Sent: Tuesday, June 12, 2001 6:39 PM
To: Multiple recipients of list ORACLE-L

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-----
Sent: Tuesday, June 12, 2001 5:05 PM
To: Multiple recipients of list ORACLE-L

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-----
Sent: Tuesday, June 12, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L

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: Paul Drake
  INET: drake_at_psscorp.com

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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: cspence_at_FuelSpot.com

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).