$APT_ORAUPSERT_COMMIT_ROW_INTERVAL

[Inquisitive]

Hi
I have set $APT_ORAUPSERT_COMMIT_ROW_INTERVAL=1000000000 in a fact load job that typically handles volumes of 100,000.

The idea is to do a database commit after all the records are inserted. If the job aborts, Oracle should do a rollback.

However, I find that the inserted records are getting committed when a job aborts. A rollback is not happening.

Any inputs ?

Thanks
Ravi Mohan

[ailuro]

Ravi, you might want to set this EV, too

  $APT_ORAUPSERT_COMMIT_TIME_INTERVAL