RE: Forever running Analyze

Also
if you are analyze table compute statistics -  you can do several command in parallel in different sessions
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>analyze table ... compute statistics for table <FONT
face=Arial color=#0000ff size=2>analyze table ... compute statistics for all indexes
<FONT
face=Arial color=#0000ff size=2><FONT face=Arial color=#0000ff size=2>analyze table ... compute statistics for all indexed columns
<FONT
face=Arial color=#0000ff size=2><SPAN
class=031585614-13062001>analyze table
... compute statistics for <col1>, <col2>, etc - for columns with squed values
<FONT
face=Arial color=#0000ff size=2><SPAN
class=031585614-13062001> 
<FONT
face=Arial color=#0000ff size=2><SPAN
class=031585614-13062001>Alex Hillman
<FONT face=Arial color=#0000ff
size=2> 

  <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:23:40 CDT