This content has been marked as final. Show 4 replies
Disk file operations I/O event is used to wait for disk file operations. It is also used for miscellaneous I/O operations such as block dumps and password file accesses.
FileOperation - Type of file operation (open, close, seek, and resize)
fileno - File identification number
filetype - Type of file (for example, log file, data file, and so on)
Yes I understand them. My question is where I can get a list of FileOperation and filetype.
FileOperation: 1 stands for open, 2 stands for read, something like this.
filetype: 1 standards for undo file, 2 stands for pwd file, something like this
Ref to "DocID 39817.1", wait event have follows,
nam What was being waited for . The wait events here are the same as are seen in view V$SESSION_WAIT Note:43718.1. For any Oracle release a full list of wait events and the values in P1, P2 and P3 below can be seen in view V$EVENT_NAME Note:43721.1
I did some research and found following.
You can get the FILETYPE for all the files accessed for your database via following query
### FILETYPE ### 0 - Other 1 - Control File 2 - Data File 3 - Log File 4 - Archive Log 6 - Temp File 9 - Data File Backup 10 - Data File Incremental Backup 11 - Archive Log Backup 12 - Data File Copy 17 - Flashback Log 18 - Data Pump Dump File
select distinct filetype_id, filetype_name from dba_hist_iostat_filetype order by 1;
### FILEOPERATION ### 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