"snapshot too old " and undo_retention 2005-09-29 - By Roger Xu
"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)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV>
<P><FONT size=2><SPAN class=452152122-29092005>"</SPAN>ANALYZE TABLE
"SAPR3"."BSIS" COMPUTE STATISTICS FOR TABLE <SPAN class=452152122-29092005
>
</SPAN>FOR ALL INDEXED COLUMNS SIZE 1 FOR ALL INDEXES<SPAN
class=452152122-29092005>"</SPAN></FONT></P>
<P><FONT size=2><SPAN class=452152122-29092005>How do I break this into pieces?
</SPAN></FONT></P>
<P><FONT size=2><SPAN class=452152122-29092005>Thanks.</SPAN></FONT></P></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B> Allen, Brandon
[mailto:Brandon.Allen@(protected)]<BR><B>Sent:</B> Thursday, September 29,
2005 4:38 PM<BR><B>To:</B> Roger Xu; Oracle-L@(protected) Org
(E-mail)<BR><B>Subject:</B> RE: "snapshot too old" and
undo_retention<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=804123621-29092005>Are
you computing stats (100% sample size)? Perhaps you could/should
estimate a small portion, like 5% instead? </SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]<B>On
Behalf Of </B>Roger Xu<BR></FONT></DIV>
<DIV>
<P><SPAN class=269431921-29092005><FONT face=Courier size=2>We have a huge
table and it takes more than 24 hours to collect its
statistics.</FONT></SPAN><BR></P></DIV></BLOCKQUOTE><FONT face=Tahoma
size=2><FONT color=#0000ff>
<P> </P></BLOCKQUOTE></FONT></FONT>
<BR>
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.
<BR>
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____<BR>
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)<BR>
</BODY></HTML>
|
|
