Re: Disk file operations I/O

  • From: Andy Klock <andy@xxxxxxxxxxxxxxx>
  • To: kylelf@xxxxxxxxx
  • Date: Wed, 18 Jan 2012 13:34:11 -0500

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


Other related posts: