RE: "snapshot too old" and undo_retention

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_at_OneNeck.com]
> Sent: Thursday, September 29, 2005 4:38 PM
> To: Roger Xu; Oracle-L_at_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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]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_at_dp7uptx.com.

-- 
Stephen Rospo        Principal Software Architect
Vallent Corporation (formerly Watchmark-Comnitel)
steve.rospo_at_vallent.com           (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