Re: Please help with ORA-01555 Snapshot too old

From: Daniel Fink <daniel.fink_at_sun.com>
Date: Tue, 22 Jul 2003 08:38:26 -0600
Message-Id: <25988.338892@fatcity.com>

This is a multi-part message in MIME format.
--------------AA4F8D067C36E40A2BBC6DB9

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Ron,

	Are the sizes of the data manipulated by the batch load the same?
	Is the db_block_size the same on each database?
	What is the size of the rbs during processing? What is the hwmsize, shrinks, extends from v$rollstat?
	You may be encountering a situation where the commit frequency is causing transaction table slots to be reused before the batch transaction can complete. In this case, the solution is to add rollback segments, not increase the size.

Daniel
--------------AA4F8D067C36E40A2BBC6DB9

Content-Type: text/x-vcard; charset=us-ascii;  name="daniel.fink.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Daniel Fink
Content-Disposition: attachment;

 filename="daniel.fink.vcf"

begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:daniel.fink_at_sun.com
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

--------------AA4F8D067C36E40A2BBC6DB9--
Received on Tue Jul 22 2003 - 09:38:26 CDT