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@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

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

Other related posts: