Re: Disk file operations I/O

@Andy Klock , Thanks his looks like a possibility:
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



@Yong Huang: thanks , DBA_HIST_IOSTAT_FUNCTION_NAME looks encouraging:

select distinct function_id, function_name from
DBA_HIST_IOSTAT_FUNCTION_NAME
order by function_id
/



FUNCTION_ID FUNCTION_NAME
----------- ------------------------------
          0 RMAN
          1 DBWR
          2 LGWR
          3 ARCH
          4 XDB
          5 Streams AQ
          6 Data Pump
          7 Recovery
          8 Buffer Cache Reads
          9 Direct Reads
         10 Direct Writes
         11 Smart Scan
         12 Archive Manager
         13 Others
which would make it an issue of LGWR on a DATAFILE.
Will look into LGWR issues and follow up.
Thanks

On Wed, Jan 18, 2012 at 7:17 PM, kyle Hailey <kylelf@xxxxxxxxx> wrote:

> 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: