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)



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

More SQL PLSQL Interview Questions

Explain aggregate functions are available there in sql?

0 Answers  


What are records give examples?

0 Answers  


What is the difference between the implicit and explicit cursors?

0 Answers  


Which is better join or inner query?

0 Answers  


Does sql profiler affect performance?

0 Answers  






list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  


What is a variable in sql?

0 Answers  


explain commit and rollback in mysql : sql dba

0 Answers  


Is id a reserved word in sql?

0 Answers  


Who developed sql?

0 Answers  


What do you mean by rowid?

0 Answers  


What does pragma mean?

0 Answers  


Categories