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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16348200/viewspace-621107/