July 2004
Intermediate to advanced
384 pages
9h 32m
English
The log file parallel write wait event has three parameters: files, blocks, and requests. In Oracle Database 10g, this wait event falls under the System I/O wait class. Keep the following key thoughts in mind when dealing with the log file parallel write wait event.
The log file parallel write event belongs only to the LGWR process.
A slow LGWR can impact foreground processes commit time.
Significant log file parallel write ...
Read now
Unlock full access