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