OT RE: Forever running Analyze

<FONT face=Arial color=#0000ff
size=2> Alex,
<FONT face=Arial color=#0000ff
size=2> 
I
cannot believe how incredibly rude you are. <FONT face=Arial color=#0000ff
size=2> 
;->

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

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Hillman, Alex   [mailto:Alex.Hillman_at_usmint.treas.gov]Sent: Wednesday, June 13,   2001 11:07 AMTo: Multiple recipients of list   ORACLE-LSubject: RE: Forever running Analyze   <FONT face=Arial color=#0000ff
  size=2>Looks like nobody offered to increase sort_area_size for the session   that is doing analyze - at least to  such size that it will require   only one merge phase. See Steve Adams web site for formula how to calculate   the size, but I think that 20M should be more than enough.   <FONT face=Arial color=#0000ff
  size=2> 
  Alex
  Hillman<FONT
  face=Tahoma>
  <FONT face=Arial
  color=#0000ff>[Hillman, Alex] 
   -----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 Wed Jun 13 2001 - 12:09:58 CDT