RE: Logical Standby Issues (cont.)

  • From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 11 Aug 2006 11:45:37 -0000

 
It looks like kind of linear search. It may be just algorithmic SQL Apply issue.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mark Strickland
Sent: 10. ágúst 2006 23:27
To: jonathan@xxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Logical Standby Issues (cont.)

I will analyze the trace file tomorrow but here are the numbers from the AWR 
snapshots:

First 10 minutes AWR Snapshot:

consistent gets                          651,393
consistent gets - examination   638,274

Next 10 minutes AWR Snapshot:

consistent gets                          372,475
consistent gets - examination   363,918         

Next 155 minutes AWR Snapshot (the remaining time that Log Miner was working):

consistent gets                          2,447,400
consistent gets - examination   2,197,323

Remaining 141 minutes  AWR Snapshot (the remaining time that SQL Apply was 
working):

consistent gets                       1,068,804
consistent gets - examination   976,315
--
//www.freelists.org/webpage/oracle-l


Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
//www.freelists.org/webpage/oracle-l


Other related posts: