| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Forever running Analyze
I checked. Raid 4. Sorry. Yes, the WAFL file system is theirs and they say you do not have to do any "Tuning" at all. And placement is supposedly not an issue. Or so they say.
-----Original Message-----
Sent: Wednesday, June 13, 2001 6:05 AM
To: Multiple recipients of list ORACLE-L
I talked to them last Friday -- RAID 4 is what they said then...
>From: Christopher Spence Reply-To: ORACLE-L_at_fatcity.com 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: ORACLE-L_at_fatcity.com >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: drake@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).
>
>_________________________________________________________________ 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: carmichr_at_hotmail.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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: Kevin Lange INET: kgel_at_ppoone.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).Received on Wed Jun 13 2001 - 11:24:19 CDT
 |
 |