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
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:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
