Unfortunately that article while being very illuminative does not include filetype 8 . Other locations semm to indicate filetype 8 might be an audit file entry. can you confirm this. We too are getting a lot of misc disk file i/o operations with filetype id as 8.
April 07, 2017 - 3:11 am UTC
You should have read it more carefully :-)
"What about FileOperation=2? After a call to Oracle support, it looks like on this version, 11.2.0.3 the values are:
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
"
So file *operation* 8 is any miscellaneous I/O we need to do.
For file *type* 8, there is no precise definition for type 8 - it basically signifies anything that is not a "particular known" form of I/O. Here's a list from 12.2 of the named file types:
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
13,Parameter File
14,DR Config file
15,OSM File
16,Change Tracking File
17,Flashback Log
18,Data Pump Dump File
19,Cross Platform Data File
20,Auto Backup File
21,OS file
22,Block Dump File
23,CSS Voting File
24,OCR File
25,ASM Staleness File
26,ASM Vol Device File
27,ASM Vol Dirty Region File
28,Password File
29,ADS AMS Relation File
30,OCR Backup File
31,ASM Parameter File
32,Flash File
33,ASM spfile backup
34,External Table File
35,Data File XTT Backup
36,OS Audit File
37,Data File Incremental Backup
38,AKM KeyStore
39,AKM AutoLogin KeyStore
40,ORS Block Pool File
41,SQL Loader File
42,AM Container File
So there is a reasonable probability that audit entries may fall into this, because there is no specific entry in the file type for writing audit logs.