Re: Logical Standby Issues (cont.)

  • From: "Mark Strickland" <strickland.mark@xxxxxxxxx>
  • To: "Rich Amick" <rAmick@xxxxxxxxxxx>
  • Date: Thu, 10 Aug 2006 16:16:20 -0700

The latch contention appears to have been fixed in  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

Other related posts: