control file sequential read
Reading from the control file. This is a common activity.
Detailed Description​
Control files are central to the way Oracle keeps track of the current state of each of the necessary database files. This tracking includes tablespace files, online and archived transaction logs and temporary files. Any time the database needs to know the state of one on the database files, the event 'control file sequential read' will happen. Examples can be:
Making a backup of the control file Sharing information (between clustered instances) Reading the state of any database file
How to reduce this wait​
If this is an issue in your database, check your server disk performance is not causing slow reads.
Make sure control files copies are on different discs. The locations of the (recommended) multiple copies can be found both in the parameter file and in the V$CONTROLFILE view.
Check if a sudden large batch load of data has caused the production of a large number of archived redo logs - all of which need to be tracked in the control file for recovery purposes.
Addition Links​
Oracle Reference - control file sequential read
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.