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