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)
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's the difference between a primary key and a unique key? : Sql dba
Can we use rowid as primary key?
Why is nosql good?
How do I save the results of sql query in a file?
What is the primary use of normalization?
What are some predefined exceptions in pl/sql?
does sql support programming? : Sql dba
What is the difference between rollback and rollback to statements?
Why do we need sharding?
Why should I use postgresql?
Does varchar need length?
Is coalesce faster than isnull?
Explian rowid, rownum? What are the psoducolumns we have?
Does truncate table reset auto increment?
How can you view the errors encountered in a trigger?