Wait Event – control file sequential read

Reading from the control file. This happens often. For example, while:
  • Making a backup of the control files
  • Sharing information (between instances) from the control file
  • Reading other blocks from the control files
  • Reading the header block

Wait Time: The wait time is the elapsed time of the read

 

Parameter Description
file# The control file from which the session is reading
block# Block number in the control file from where the session starts to read. The block size is the physical block size of the port (usually 512 bytes, some UNIX ports have 1 or 2 Kilobytes).
blocks The number of blocks that the session is trying to read

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 )

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.