I talked to them last Friday -- RAID 4 is what they said then...
>From: Christopher Spence Reply-To: [EMAIL PROTECTED] To: Multiple
>recipients of list ORACLE-L Subject: RE: Forever running Analyze Date: Tue,
>12 Jun 2001 18:30:52 -0800
>
>Last time I talked to them (6 months ago) it was Raid 5
>
>"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 9:56 PM To:
>Multiple recipients of list ORACLE-L
>
>
>Paul,
>
>They are RAID 4. And WAFL is their own proprietary system and you have very
>little control over allocation. You don't need to worry about it. (or so
>the
>
>sales rep and engineer said)
>
>Rachel
>
>
> >From: Paul Drake >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients
>of list ORACLE-L >Subject: RE: Forever running Analyze >Date: Tue, 12 Jun
>2001 15:10:53 -0800 > >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: [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).
>
>_________________________________________________________________ Get your
>FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com --
>Author: Rachel Carmichael 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). --
>Please see the official ORACLE-L FAQ: http://www.orafaq.com --
>Author: Christopher Spence 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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).
