Thanks for the help folks Posted some info on my blog http://dboptimizer.com/2012/01/19/buffer-busy-waits-and-disk-file-operations-io/ Still investigating - Kyle Hailey On Wed, Jan 18, 2012 at 10:34 AM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote: > On Tue, Jan 17, 2012 at 11:34 PM, kyle Hailey <kylelf@xxxxxxxxx> wrote: > Would love to know the translations. > > > Probably a better way but this should give you a hint: > > SQL> select distinct filetype_id, filetype_name from > DBA_HIST_IOSTAT_FILETYPE order by 1; > > FILETYPE_ID FILETYPE_NAME > ----------- ------------------------------ > 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 > > 12 rows selected. > > -- //www.freelists.org/webpage/oracle-l