Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5281 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
what is rdbms? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What plvcmt and plvrb does in pl/sql?
How do I trace sql profiler?
Can we insert data into materialized view?
What is the use of pl/sql table?
Why join is faster than subquery?
Can a view be mutating? If yes, then how?
how to present a past time in hours, minutes and seconds? : Sql dba
what is bdb (berkeleydb)? : Sql dba
What is a pragma statement?
What is nested table in pl sql?
How to raise user-defined exception with custom sqlerrm ?
What is sql keyword?
What is pl sql script?
