_wait_for_sync
Parameter type | boolean | Default value | TRUE |
Parameter class | static | Range of Values | TRUE | FALSE |
Wait for sync on commit.
_wait_for_sync = FALSE
When set to FALSE, will allow the system to complete commits without waiting for the redo log buffer flushes to complete. However, a database can then not be restored if it crashes.
_wait_for_sync = TRUE
Waits for redo log buffer flushes to complete before commits are completed.