RE: "snapshot too old" and undo_retention

"ANALYZE TABLE "SAPR3"."BSIS" COMPUTE STATISTICS FOR TABLE  FOR ALL INDEXED 
COLUMNS SIZE 1 FOR ALL INDEXES"

How do I break this into pieces? 

Thanks.

-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx]
Sent: Thursday, September 29, 2005 4:38 PM
To: Roger Xu; Oracle-L@Freelists. Org (E-mail)
Subject: RE: "snapshot too old" and undo_retention


Are you computing stats (100% sample size)?  Perhaps you could/should estimate 
a small portion, like 5% instead? 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Roger Xu


We have a huge table and it takes more than 24 hours to collect its statistics.


 


This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use of this e-mail by persons 
or entities other than the addressee is prohibited. If you have received this 
e-mail in error, please contact the sender immediately and delete the material. 
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security 
System. Any questions please call 972-721-8257 or email your request to 
tech_support@xxxxxxxxxxxx

Other related posts: