Re: Disk file operations I/O

From: Andy Klock <andy_at_oracledepot.com>
Date: Thu, 19 Jan 2012 14:17:11 -0500
Message-ID: <CADo_RaM3Oh+QOj7n9g-JkX=M52EiakzUQ2jPoGVoyAWVxbrjBw_at_mail.gmail.com>

Awesome. I noticed late yesterday that I only provided one side of the mappings you were asking about. With the file operation mapping (thanks Yong) you've got a nice direction to go down. Look forward to hearing about the outcome.
On Thu, Jan 19, 2012 at 2:08 PM, kyle Hailey <kylelf_at_gmail.com> wrote: ...
>
>
> _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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 19 2012 - 13:17:11 CST