Don't ya just love acronyms.. What is EIM and IFB???

-----Original Message-----
From: Diane_Fukuhara [mailto:oracledba-ezmlmshield-x18348971.[Email address protected]
Sent: Monday, December 31, 2007 11:03 AM
To: LazyDBA Discussion
Subject: EIM question


When we run our EIM it's set in our ifb file for 5000-50999 which is supposed to commit every 1000 records. Our developer has coded the batches so it uses oracle sequence numbers so it keeps changing and it resets only after reaching 50999. In our 10G environment we have seen this hang the
database, but in 8i this was fine. The fix was to change the ifb file so
only two batches are executed. Does anyone know why this doesn't work in 10G, but does in 8i?










---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page