Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
"snapshot too old " and undo_retention

"snapshot too old " and undo_retention

2005-09-29       - By Roger Xu

Reply:     1     2     3     4     5     6     7     8     9     10     >>  

"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&nbsp;<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)?&nbsp; Perhaps you could/should
 estimate a small portion, like 5% instead?&nbsp;</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>&nbsp;</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>