A COMMIT concludes a transaction. When a COMMIT is executed, the database system saves all the changes carried out by the transaction. The system can no longer use a ROLLBACK to reverse any changes that are completed by a COMMIT.
After a COMMIT, the database system releases all locks that have been allocated to the transaction and implicitly opens a new transaction.
ON |
The database system performs all the necessary COMMIT actions automatically. |
OFF |
You have to enter COMMIT commands explicitly. |
SQL Reference Manual, COMMIT Statement
Database Studio, Configuring Database Studio
SQLCLI, Overview of All SQLCLI Commands
Loader, AUTOCOMMIT Command