Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Logical Standby Issues (cont.)

Re: Logical Standby Issues (cont.)

From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Thu, 10 Aug 2006 16:16:20 -0700
Message-ID: <90ad14210608101616t3243ff7cp1336f19ab58be721@mail.gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US