Wait Event – control file parallel write

This event occurs while the session is writing physical blocks to all control files. This happens when:
  • The session starts a control file transaction (to ensure the control files are up to date in case the session crashes before committing the control file transaction)
  • The session commits a transaction to a control file
  • Changing a generic entry in the control file, the new value is being written to all control files

Wait Time: The wait time is the time it takes to finish all writes to all control files

Parameter Description
files The number of control files to which the session is writing
blocks The number of blocks that the session is writing to the control file
requests The number of I/O requests which the session wants to write

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.