Tbs READ ONLY and Snapshot too old 2004-06-11 - By Justin Cave
ORA-01555 (See ORA-01555.ora-code.com) indicates that Oracle was attempting to reconstruct the state of a
block and the earlier state was not available in the undo segments. By
definition, you cannot get an ORA-01555 (See ORA-01555.ora-code.com) error when trying to access a
read-only object.
Do you get these ORA-01555 (See ORA-01555.ora-code.com) errors shortly after doing the load or do you get
them throughout the day? The only thing I can think is that these errors
are caused by delayed block cleanout, but that should take care of itself
soon after the load. If you get errors throughout the month, I would
suspect that the big tables aren 't the cause.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com <http://www.ddbcinc.com/askDDBC > /askDDBC
__ __
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Friday, June 11, 2004 4:15 AM
To: oracle-l@(protected)
Subject: Tbs READ ONLY and Snapshot too old
Hi List,
just a little question about read only tbs :
We have big tables that are loaded once and never updated during the month ,
so I think it 's a good thing to switch their tbs to read only mode.
Web have a lot of script that request thoses heavy tables to build small
tables and we often encounter ORA-01555 (See ORA-01555.ora-code.com).
Do you think that "in general " this operation could enhance our ORA-01555 (See ORA-01555.ora-code.com)
problems ?
TIA
Philippe
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD > <TITLE >Tbs READ ONLY and Snapshot too old </TITLE >
<META http-equiv=Content-Type content= "text/html; charset=us-ascii " >
<META content= "MSHTML 6.00.3790.118 " name=GENERATOR > </HEAD >
<BODY >
<DIV dir=ltr align=left > <FONT face=Arial color=#0000ff size=2 > <SPAN
class=359271110-11062004 >ORA-01555 (See ORA-01555.ora-code.com) indicates that Oracle was attempting to
reconstruct the state of a block and the earlier state was not available in the
undo segments. By definition, you cannot get an ORA-01555 (See ORA-01555.ora-code.com) error when
trying to access a read-only object. </SPAN > </FONT > </DIV >
<DIV dir=ltr align=left > <FONT face=Arial color=#0000ff size=2 > <SPAN
class=359271110-11062004 > </SPAN > </FONT > </DIV >
<DIV dir=ltr align=left > <FONT face=Arial color=#0000ff size=2 > <SPAN
class=359271110-11062004 >Do you get these ORA-01555 (See ORA-01555.ora-code.com) errors shortly after doing
the load or do you get them throughout the day? The only thing I can think
is that these errors are caused by delayed block cleanout, but that should take
care of itself soon after the load. If you get errors throughout the
month, I would suspect that the big tables aren 't the cause. </SPAN > </FONT > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > </FONT > </DIV >
<DIV align=left > <FONT face=Arial size=2 >Justin Cave </FONT > </DIV >
<DIV align=left > <FONT face=Arial size=2 >Distributed Database Consulting,
Inc. </FONT > </DIV >
<DIV align=left > <FONT face=Arial > <FONT size=2 > <A
href= "http://www.ddbcinc.com/askDDBC " >http://www.ddbcinc.com <SPAN
class=359271110-11062004 >/askDDBC </A > </SPAN > </FONT > </FONT > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > </FONT > </DIV > <BR >
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left >
<HR tabIndex=-1 >
<FONT face=Tahoma size=2 > <B >From: </B > oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B >On Behalf Of </B >NGUYEN Philippe
(Cetelem) <BR > <B >Sent: </B > Friday, June 11, 2004 4:15 AM <BR > <B >To: </B >
oracle-l@(protected) <BR > <B >Subject: </B > Tbs READ ONLY and Snapshot too
old <BR > </FONT > <BR > </DIV >
<DIV > </DIV >
<P > <FONT size=2 >Hi List, </FONT > <BR > <FONT size=2 >just a little question about
read only tbs : </FONT > <BR > <FONT size=2 >We have big tables that are loaded once
and never updated during the month , </FONT > <BR > <FONT size=2 >so I think it 's a
good thing to switch their tbs to read only mode. </FONT > <BR > <FONT size=2 >Web
have a lot of script that request thoses heavy tables to build small tables and
we often encounter ORA-01555 (See ORA-01555.ora-code.com). </FONT > <BR > <FONT size=2 >Do you think that "in
general " this operation could enhance our ORA-01555 (See ORA-01555.ora-code.com) problems ? </FONT > <BR > <FONT
size=2 >TIA </FONT > <BR > <FONT size=2 >Philippe </FONT > </P > </BODY > </HTML >
|
|
