Re: Disk file operations I/O
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: Andy Klock <andy@xxxxxxxxxxxxxxx>
- Date: Wed, 18 Jan 2012 19:17:11 -0800
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.
>
>
--
http://www.freelists.org/webpage/oracle-l
Other related posts: