1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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


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

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

What is sql stand for?

0 Answers  

What is window clause?

1 Answers   TCS,

how to calculate the difference between two dates? : Sql dba

0 Answers  

What is a primary key sql?

0 Answers  




where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

how to create user in sql and how to set password for that?

3 Answers  

How can I speed up sql query?

0 Answers  

What is benefit of creating memory optimized table?

0 Answers  

How do I find duplicates in the same column?

0 Answers  

Can you join a table to itself?

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

For more SQL PLSQL Interview Questions Click Here
Categories