Looking for some help. We are doing an evaluation of Oracle 7 on for
SunOS 4.1.3. We have a ProC program which performs the following
function.
define cursor 1 select from A,B,C where A.a = B.a and B.b = C.b;
open cursor 1;
fetch record;
while records remain
depending on record type loop n times (where n <= 50)
insert into table D;
COMMIT;
fetch next record
endwhile
When we run a single process, all is well. When we attempt to run five
processes simulateously we get Oracle error -1555 "Snapshot is too old".
We have tried just about everything which we can think of including
assigning this transaction to a rollback segment with an itial size of
35M!
We are terribly confused as to exact what information Oracle is attempting
to take a snapshot of. Also, since we do a commit after each insert we
would not expect an excessive accumulation of rollback information.
