|
Database Write Mode
Data is written synchronously
When this option is selected, data is flushed immediately to disk. Database write transactions do not complete until the data has been physically written to the disk. This is the default selection and is safest for your data.
Data is written asynchronously
When this option is selected, the operating system controls when the data is physically written to the disk. This option offers superior performance, but it increases the risk of database corruption in the event of a power outage or other uncontrolled shutdown of the server and/or database. Asynchronous write mode is only recommended when the performance of synchronous write mode is not sufficient. It is critical that the system be protected by a reliable uninterruptible power supply (UPS) and that database backups are maintained.
