t Oracle Commit Frequency

welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com

The Best Oracle Commit Frequency

Oracle Tips by Burleson Consulting
June 17, 2011

Question: What is the best practice for using commit processing on
Oracle PL/SQL Blocks? Is it best to commit frequently to release
database resources?

Answer: The best oracle commit frequency is never to explicitly commit
and let the entire update complete as a single transaction, but there
are exceptions.

As a general rule, the best practice is to dedicate an undo log
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------