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
- 5299 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 are the different dcl commands in sql?
What is varchar sql?
what is try_catch block in procedure
How to combine two stored procedures in sql?
Do we need to create index on primary key?
What does (*) mean in sql?
What are hotfixes and patches?
What are the different types of dbmss?
What are the different tcl commands in sql?
Define commit?
define sql insert statement ? : Sql dba
when is the use of update_statistics command? : Sql dba
Show how functions and procedures are called in a pl/sql block.
what are the advantages of sql ? : Sql dba
Does sql*plus have a pl/sql engine?
