Tbs READ ONLY and Snapshot too old 2004-06-11 - By NGUYEN Philippe (Cetelem)
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 3.2//EN " >
<HTML >
<HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META NAME= "Generator " CONTENT= "MS Exchange Server version 5.5.2657.73 " >
<TITLE >Tbs READ ONLY and Snapshot too old </TITLE >
</HEAD >
<BODY >
<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 >
|
|
