InterviewSolution
| 1. |
What Is The Difference Between Sync/async, Lgwr/arch, And Affirm/noaffirm ? |
|
Answer» Specifies that network I/O is to be done synchronously (SYNC) or asynchronously (ASYNC) when archival is performed USING the LOG writer process (LGWR). Specifies whether redo transport SERVICES use archiver processes (ARCn) or the log writer process (LGWR) to collect transaction redo data and transmit it to standby DESTINATIONS. If neither the ARCH or LGWR attributes are specified, the default is ARCH. Controls whether redo transport services use synchronous or asynchronous I/O to write redo data to disk AFFIRM—specifies that all disk I/O to archived redo log files and standby redo log files is performed synchronously and completes successfully before the log writer process CONTINUES. NOAFFIRM—specifies that all disk I/O to archived redo log files and standby redo log files is performed asynchronously; the log writer process on the primary database does not wait until the disk I/O completes before continuing. Specifies that network I/O is to be done synchronously (SYNC) or asynchronously (ASYNC) when archival is performed using the log writer process (LGWR). Specifies whether redo transport services use archiver processes (ARCn) or the log writer process (LGWR) to collect transaction redo data and transmit it to standby destinations. If neither the ARCH or LGWR attributes are specified, the default is ARCH. Controls whether redo transport services use synchronous or asynchronous I/O to write redo data to disk AFFIRM—specifies that all disk I/O to archived redo log files and standby redo log files is performed synchronously and completes successfully before the log writer process continues. NOAFFIRM—specifies that all disk I/O to archived redo log files and standby redo log files is performed asynchronously; the log writer process on the primary database does not wait until the disk I/O completes before continuing. |
|