Re: Logical Standby Issues (cont.)

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

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 10 2006 - 18:27:13 CDT