Re: Disk file operations I/O

From: Andy Klock <andy_at_oracledepot.com>
Date: Wed, 18 Jan 2012 13:34:11 -0500
Message-ID: <CADo_RaMHZY+mwBSJK_nSN8aHRL+-X=KfmOXjGwmmEPW8vseJUQ_at_mail.gmail.com>

On Tue, Jan 17, 2012 at 11:34 PM, kyle Hailey <kylelf_at_gmail.com> 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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 18 2012 - 12:34:11 CST