Is there any problem if we use commit repeatedly after each dml statement in a

Is there any problem if we use commit repeatedly after each
dml statement in a plsq procedure ? (eg. there are 10 update
stmt and using 10 commit stmt after each update stmt)

Question Posted / meher

1 Answers
4764 Views
I also Faced
E-Mail Answers

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (e..

Answer / kiran iyer

Commiting a record frequently will effect the performance as
oracle internally would wait for the transaction to get
commited and then flush the RBS and then would go ahead and
read the Next Record. Hence it is not a good Practice to
commit records frequently. Records should be commited in a
batch.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer