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