| 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
Interesting, I wouldn't be surprized with that statement.
"Walking on water and developing software from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Wednesday, June 13, 2001 7: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: 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).Received on Wed Jun 13 2001 - 07:27:54 CDT
 |
 |