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
- 5441 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
Why we use cross join?
Can we use distinct and group by together?
How to call a javascript function from pl sql?
What is string join?
What is nvarchar in sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Is a view faster than a stored procedure?
How to call shell script from pl sql procedure?
How do you bind variables in pl sql?
What are different categories of sql commands?
How does sql store data?
How do you update a table in sql?
What is memory optimized?
What is the difference between jpql and sql?
