RE: OT RE: Forever running Analyze

It was
a joke.
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>Generally when there is a :) or a >:-) or something similar near the end of a comment, it is ussually noted to be sarcastic.  
 
"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: Nguyen, Long (ITS, Limestone   Ave) [mailto:Long.Nguyen_at_its.csiro.au]Sent: Thursday, June 14, 2001   1:50 AMTo: Multiple recipients of list ORACLE-LSubject:   RE: OT RE: Forever running Analyze
  <SPAN
  class=543055104-14062001>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 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>;->
     
<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> 
      <FONT face=Arial color=#0000ff 
      size=2>Alex Hillman<SPAN 
      class=359040514-13062001>
      <FONT face=Arial 
      color=#0000ff>[Hillman, Alex] 
      <SPAN 
      class=359040514-13062001> -----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 face=Arial color=#0000ff 
        size=2>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>    <SPAN 
        class=670072920-12062001>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