Re: Disk file operations I/O

From: kyle Hailey <kylelf_at_gmail.com>
Date: Wed, 18 Jan 2012 19:17:11 -0800
Message-ID: <CADsdiQjFgLgkifUmLe9cAZtF7=XZvJ3zWWftnHjUKJQYTKq_oA_at_mail.gmail.com>

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_at_oracledepot.com> wrote:

> 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 - 21:17:11 CST