"snapshot too old " and undo_retention 2005-09-29 - By Steve Rospo
Check the docs for DBMS_STATS.GATHER_TABLE_STATS, in particular estimate
statistics and block sampling options. Also review Kirti's suggestions,
there are some good pointers.
S-
On Thu, 29 Sep 2005, Roger Xu wrote:
> "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@(protected)]
> Sent: Thursday, September 29, 2005 4:38 PM
> To: Roger Xu; Oracle-L@(protected) 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@(protected) [mailto:oracle-l-bounce@(protected)]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@(protected)
--
Stephen Rospo Principal Software Architect
Vallent Corporation (formerly Watchmark-Comnitel)
steve.rospo@(protected) (425)564-8145
This email may contain confidential information. If you received this in
error, please notify the sender immediately by return email and delete this
message and any attachments. Thank you.
--
http://www.freelists.org/webpage/oracle-l
|
|
