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
- 5377 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 the difference between distinct and unique in sql?
Are subqueries faster than joins?
what is the difference between union and union all? : Sql dba
What are the syntax and use of the coalesce function?
What are the different sql languages?
What is data control language?
how to run 'mysql' commands from a batch file? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
Can a table contain multiple foreign key’s?
Are pl sql variables case sensitive?
What is the difference between inner join and outer join?
What is sql and also describe types of sql statements?
Is not equal in sql?
Mention what are the benefits of pl/sql packages?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
