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)
- 1 Answers
- 4916 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Which is faster subquery or join?
What operating systems are supported by oracle sql developer?
What are different clauses used in sql?
Does truncate need commit?
what are the different type of normalization? : Sql dba
What are the different dml commands in sql?
what are the limitations of identity column? : Transact sql
how can we submit a form without a submit button? : Sql dba
What is the life of an sql statement?
What is sqlca in db2?
How bulk collect improves performance?
how is myisam table stored? : Sql dba
Can we create view in stored procedure?
How do you use collections in procedure to return the resultset?
What are character functions in sql?
