Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT RE: Forever running Analyze

RE: OT RE: Forever running Analyze

From: Nguyen, Long (ITS, Limestone Ave) <Long.Nguyen_at_its.csiro.au>
Date: Sun, 17 Jun 2001 20:55:54 -0700
Message-ID: <F001.0032CC53.20010617204519@fatcity.com>

Thanks
Chris for letting mw know.
<SPAN
class=493174803-18062001> 
And
sorry Ross that I did not see the humour in your message. <SPAN
class=493174803-18062001> 
<SPAN
class=493174803-18062001>Long

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Christopher Spence   [mailto:cspence_at_FuelSpot.com]Sent: Friday, 15 June 2001 12:07   AMTo: Multiple recipients of list ORACLE-LSubject: RE:   OT RE: Forever running Analyze
  It
  was a joke.
  <FONT color=#0000ff face=Arial
  size=2> 
  <FONT color=#0000ff face=Arial
  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 color=#0000ff face=Arial
size=2> Alex,
<FONT color=#0000ff face=Arial
size=2> 
<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]  <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 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
Received on Sun Jun 17 2001 - 22:55:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US