RE: OT RE: Forever running Analyze

[Christopher Spence]

It was a joke.

 

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
Oracle DBA
Fuelspot

-----Original Message-----
From: Nguyen, Long (ITS, Limestone Ave) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 1:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Forever running Analyze

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

 

Long

-----Original Message-----
From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 14 June 2001 2:57 AM
To: Multiple recipients of list ORACLE-L
Subject: OT RE: Forever running Analyze

 Alex,

 

I cannot believe how incredibly rude you are.

 

;->

 

Ross

-----Original Message-----
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L
Subject: 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.

 

Alex Hillman

[Hillman, Alex] 

 -----Original Message-----
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Forever running Analyze

Hi folks;

  We have an Analyze running that is taking forever.  Here is the setup:

    The table is about 250 bytes wide.

    The table is normally 100,000 rows

    The table has grown to over 4,000,000 rows.

    There is one index on 1 column.

    We used the Compute Statistics options

 

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

 

Thanks

 

Kevin