Re: Disk file operations I/O

From: kyle Hailey <kylelf_at_gmail.com>
Date: Thu, 19 Jan 2012 11:08:49 -0800
Message-ID: <CADsdiQiXf4D75pWjR5TWkaKkAAtZWA002ExyjG5TUJdT6Eyvcw_at_mail.gmail.com>

_at_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

_at_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_at_gmail.com> 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_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 Thu Jan 19 2012 - 13:08:49 CST