RE: OT RE: Forever running Analyze

Sorry
Ross, maybe  I missed it, but I did not see any rudeness in Alex's message.

<SPAN
class=543055104-14062001> 
<SPAN
class=543055104-14062001>Long

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mohan, Ross   [mailto:MohanR_at_STARS-SMI.com]Sent: Thursday, 14 June 2001 2:57   AMTo: Multiple recipients of list ORACLE-LSubject: OT   RE: Forever running Analyze
  <FONT color=#0000ff face=Arial
  size=2> Alex,
  <FONT color=#0000ff face=Arial
  size=2> 
  I
  cannot believe how incredibly rude you are.   <FONT color=#0000ff face=Arial
  size=2> 
  <FONT color=#0000ff face=Arial
  size=2>;->
   
  <FONT color=#0000ff face=Arial
  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 color=#0000ff face=Arial
    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 color=#0000ff face=Arial
    size=2> 
    <FONT color=#0000ff face=Arial
    size=2>Alex Hillman<SPAN
    class=359040514-13062001>
    <FONT color=#0000ff
    face=Arial>[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     

<FONT color=#0000ff face=Arial

      size=2>Hi folks;


      <FONT color=#0000ff face=Arial 

      size=2>  We have an Analyze running that is taking forever.  
      Here is the setup:


      <FONT color=#0000ff face=Arial 

      size=2>    The table is about 250 bytes 
      wide.


      <FONT color=#0000ff face=Arial 

      size=2>    The table is normally 100,000 
      rows


      <FONT color=#0000ff face=Arial 

      size=2>    The table has grown to over 4,000,000 
      rows.


      <FONT color=#0000ff face=Arial 

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


      <FONT color=#0000ff face=Arial 

      size=2>    <SPAN 
      class=670072920-12062001>We used the 
      Compute Statistics options


      <FONT color=#0000ff face=Arial 

      size=2> 


      <FONT color=#0000ff face=Arial 

      size=2>Does anyone have any suggestions on how we can get this analyze to 
      complete and still generate worthwile statistics ??


      <FONT color=#0000ff face=Arial 

      size=2> 


      <FONT color=#0000ff face=Arial 

      size=2>Thanks


      <FONT color=#0000ff face=Arial 

      size=2> 


      <FONT color=#0000ff face=Arial 

      size=2>Kevin