Wait Event "Disk file operations I/O"

Oralce has a lot of waiting events, and today a new wait event was found in the AWR report of a database: Disk file operations I/O, as the official explanation is as follows:

This event was used to wait for disk file operations (for example, open, close, seek, and resize). It is also used for miscellaneous I/O operations such as block dumps and password file accesses.

Wait Time: The wait time is the actual time it takes to do the I/O

Parameter	Description
FileOperation	Type of file operation
Fileno	File Identification number
FileType	Type of file (for example, log file, data file, and so on)

We know that the operating system needs to open files, close files, locate file locations, and so on when the operation is in progress, and Oracle is in a waiting state when these operations are performed.

These file operations of the operating system can be divided as follows:

1.file creation
2 File Open
3 File Resize
4 File deletion
5 File Close
6 wait for all AIO requests to finish
7 Write verification
8 Wait for miscellaneous IO (FTP, block dump, passwd file)
9 read from snapshot files

Most of these operations are related to the operating system I/O, and the database itself is not related to the parameter wait, the database appears disk file operations I/O wait events often can also see another familiar wait event: log file sync;

Via

Http://blog.sina.com.cn/s/blog_450e72d10101o2qc.html

Wait Event "Disk file operations I/O"