RE: "snapshot too old" and undo_retention
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 17:23:14 -0500
"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:
