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

What does an inner join do?

0 Answers  


scope of exception handling in plsql

4 Answers   Wipro,


What is column?

0 Answers  


what is constraining table?

2 Answers  


what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  


What is interval partition?

0 Answers  


What are sql injection vulnerabilities?

0 Answers  


what is meant by DML?

5 Answers   HCL,


difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,


What is indexing in sql and its types?

0 Answers  


Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,


What are the various restrictions imposed on view in terms of dml?

0 Answers  


Categories