Sign Up Login


  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

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

Which is better join or subquery?

0 Answers  

How do I sort a table in sql?

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

Is sql a oracle?

0 Answers  




how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

What is mdf ldf and ndf?

0 Answers  

What are data types in pl sql?

0 Answers  

How can check sql version from command line?

0 Answers  

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

What is partition in sql query?

0 Answers  

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

For more SQL PLSQL Interview Questions Click Here
Categories