RE: Tbs READ ONLY and Snapshot too old

From: Justin Cave <justin_at_askddbc.com>
Date: Fri, 11 Jun 2004 05:16:04 -0600
Message-Id: <20040611105832.B988772C00F@turing.freelists.org>

If the big tables are not changing, you can't get ORA-01555 errors throughout the month from those tables. It sounds like the errors are coming from your smaller tables, or at least tables other than your big tables. That, or these processes are updating the big tables...

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com <http://www.ddbcinc.com/askDDBC> /askDDBC

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Friday, June 11, 2004 5:16 AM
To: oracle-l_at_freelists.org
Subject: RE: Tbs READ ONLY and Snapshot too old

thank Justin,
Errors occurs during the month but we have a very bad application that generate sql scripts with a lot of cursors opened on thoses big tables ( more than 20Go per tables) thoses script create small tables (10 - 200 Mo) with datas pick up from the different big tables. The problem is that the generated script are often launch in the same time and I we can't touch the code.

Philippe Nguyen
CETELEM - Administration, Architecture Décisionnelle Direction Customer Relationship Management E-Mail : philippe.nguyen_at_cetelem.fr
Tel : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88

-----Message d'origine-----
De : oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]De la part de Justin Cave
Envoyé : vendredi 11 juin 2004 12:15
À : oracle-l_at_freelists.org
Objet : RE: Tbs READ ONLY and Snapshot too old

ORA-01555 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 error when trying to access a read-only object.

Do you get these ORA-01555 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Friday, June 11, 2004 4:15 AM
To: oracle-l_at_freelists.org
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. Do you think that "in general" this operation could enhance our ORA-01555 problems ?
TIA
Philippe

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 11 2004 - 06:15:36 CDT