There is a batch process which is running in a session A. It is deleting, inserting and updating records and finally at the end doing a commit. Whenever any exception entire process is getting rollback. Usually this is taking 4-5 hrs and there is no prob with time. Client is happy with the time.
But there is a requirement from customer to observe how many records inserted, deleted and updated in a different table, which is there in different session B.
Both should happen parallel.
Note:Commit is at the end and there are 2 diff sessions. Is this possible? What are the possible approaches?
Thanks in advance.