The latch contention appears to have been fixed in 10.2.0.2. My tests
in that version showed no latch contention. Here are the statistics
you requested from the AWR report. This is for the time period after
Log Mining completed and while SQL Apply was continuing, 141 minutes.
The per Trans numbers don't make sense to me. In the Load Profile
section, there isn't a value for Transactions. During this time
period, the SQL update statement had 235,162 executions with 5.08
gets/exec and .02 physical reads/exec.
Statistic Total per Second per Trans
===================================
parse time cpu 1,176 0.14 45.23
db block gets 266,030 31.36 10,231.92
consistent gets 1,068,804 125.98 41,107.85
physical reads direct 192 0.02 7.38
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 10 2006 - 18:16:20 CDT
