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

Are views faster than queries?

0 Answers  


how to find 5th row ?

10 Answers  


What types of commands can be executed in sql*plus?

0 Answers  


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  


What does a pl/sql package consist of?

0 Answers  


What are pl/sql packages?

0 Answers  


what is a constraint? : Sql dba

0 Answers  


how will i became good database developer?

1 Answers  


Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,


Is primary key clustered index?

0 Answers  


Can you have a foreign key without a primary key?

0 Answers  


Is sql injection illegal?

0 Answers  


Categories