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
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> 
  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 - 16:09:13 CDT