COMMIT WAIT: The commit does not return as successful until the redo corresponding to the commit is persisted in the online redo logs (default).
COMMIT NOWAIT: The commit should return to the application without waiting for the redo to be written to the online redo logs.
COMMIT IMMEDIATE: The log writer process should write the redo for the commit immediately (default). In other words, this option forces a disk I/O.
COMMIT BATCH: Oracle Database should buffer the redo. The log writer process is permitted to write the redo to disk in its own time.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16348200/viewspace-621107/，如需转载，请注明出处，否则将追究法律责任。