RE: Forever running Analyze

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> 
  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 - 10:33:46 CDT