control file parallel write
The control 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 thought in mind when dealing with the control file parallel write wait event.
The control file parallel write waits usually are symptomatic of high log switches.
Common Causes, Diagnosis, and Actions
A session with the control file parallel write wait event indicates that it has performed control file transactions. Operations such as log switching and adding or removing data files require the control file to be updated. Control ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
