RE: Forever running Analyze

if you
cannot do the oracle "assessed estimate" of 3GB/hour then perhaps the IO system is in need of modification or replacement.  
"Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Fuelspot

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mohan, Ross   [mailto:MohanR_at_STARS-SMI.com]Sent: Tuesday, June 12, 2001 6: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.
  <FONT face=Arial color=#0000ff
  size=2> 
  ok,
  can't do that?
  <FONT face=Arial color=#0000ff
  size=2> 
  <FONT face=Arial color=#0000ff
  size=2>then
  <FONT face=Arial color=#0000ff
  size=2> 
  tune
  the i/o system
  <FONT face=Arial color=#0000ff
  size=2>can't?
  ok,
  then partition the table/index to faster/more/different   drives
  <FONT face=Arial color=#0000ff
  size=2>can't?
  ok,
  then run the analyze at night via cron   <FONT face=Arial color=#0000ff
  size=2>can't
  ok,
  then screw it, it's not worth it.  ( just kidding )   

<FONT face=Tahoma

    size=2>-----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;
<FONT face=Arial color=#0000ff

    size=2>  We have an Analyze running that is taking forever.  Here     is the setup:
<FONT face=Arial color=#0000ff

    size=2>    The table is about 250 bytes     wide.
<FONT face=Arial color=#0000ff

    size=2>    The table is normally 100,000     rows
<FONT face=Arial color=#0000ff

    size=2>    The table has grown to over 4,000,000     rows.
<FONT face=Arial color=#0000ff

    size=2>    There is one index on 1
column.

<FONT face=Arial color=#0000ff

    size=2>    <FONT
    face=Arial color=#0000ff size=2>We used the Compute Statistics     options
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>Does anyone have any suggestions on how we can get this analyze to     complete and still generate worthwile statistics ??
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>Thanks
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>Kevin Received on Tue Jun 12 2001 - 17:37:37 CDT