Please help with ORA-01555 Snapshot too old

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 22 Jul 2003 09:05:33 -0500
Message-Id: <25988.338886@fatcity.com>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C3505A.5129F39E
Content-Type: text/plain;

charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Help!
=20
I have a production and a test database, both with 3000mg RBS tablespaces with two datafiles. Both have db_block_buffers set at 1000. The only difference is the production db has 7 rollback segments and the test db has 8. The rollback segments are sized at 50mg each on both databases.
=20
The problem is, at night when the batch load is running (by itself), the load fails with a ORA-01555. The data is the same on both loads. Nothing else is going on in the database during the load. =20
Any ideas?
=20
Ron

=20

------_=_NextPart_001_01C3505A.5129F39E
Content-Type: text/html;

charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word"><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml_at_01C35074.4A7F7000" rel=3DFile-List><!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>

</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {

font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; = mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; } P.MsoNormal {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
LI.MsoNormal {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
DIV.MsoNormal {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-style-parent: ""; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman" }
A:link {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
SPAN.MsoHyperlink {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
A:visited {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
SPAN.MsoHyperlinkFollowed {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
P.MsoAutoSig {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" }
LI.MsoAutoSig {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" }
DIV.MsoAutoSig {

FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; = mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" }
P {

FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: = "Times New Roman"; mso-pagination: widow-orphan; = mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; = mso-margin-bottom-alt: auto
}
SPAN.EmailStyle19 {

COLOR: navy; mso-style-type: personal; mso-ansi-font-size: 10.0pt; = mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial
}
SPAN.EmailStyle20 {

COLOR: #993366; mso-style-type: personal-reply; mso-ansi-font-size: = 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial
}
DIV.Section1 {

        page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US style=3D"tab-interval: .5in" vLink=3Dblue =
link=3Dblue>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D164575713-22072003>Help!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D164575713-22072003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D164575713-22072003>I have=20
a production and a test database, both with 3000mg RBS tablespaces with = two=20
datafiles.  Both have db_block_buffers set at 1000.  The only=20 difference is the production db has 7 rollback segments and = the test=20
db has 8.  The rollback segments are sized at 50mg each on both=20 databases.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D164575713-22072003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D164575713-22072003>The=20
problem is, at night when the batch load is running (by itself), the = load fails=20
with a ORA-01555.  The data is the same on both loads.  = Nothing else=20
is going on in the database during the load.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D164575713-22072003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D164575713-22072003>Any=20
ideas?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D164575713-22072003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D164575713-22072003>Ron</SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV></DIV>
  <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr = align=3Dleft><![if !supportEmptyParas]><![endif]><![if =

!supportEmptyParas]><![endif]><![if !supportEmptyParas]><![endif]><![if =
!supportEmptyParas]><![endif]><![if !supportEmptyParas]><![endif]><![if =
!supportEmptyParas]><![endif]><![if !supportEmptyParas]><![endif]><![if =
!supportEmptyParas]><![endif]><![if !supportEmptyParas]><![endif]><![if =
!supportEmptyParas]><![endif]><![if !supportEmptyParas]><![endif]><![if =
!supportEmptyParas]><![endif]><![if !supportEmptyParas]><![endif]><FONT=20

face=3DArial color=3Dblue size=3D2><SPAN=20 style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: = Arial"></SPAN></FONT><FONT=20
face=3DArial color=3D#0000ff size=3D2><SPAN=20 Received on Tue Jul 22 2003 - 09:05:33 CDT