Re: High Number of undo writes

From: Purav Chovatia <puravc_at_gmail.com>
Date: Mon, 21 May 2012 15:03:22 +0530
Message-ID: <CADrzpjHHRJ4Dmnxe0dRKsx0WU7yv3DrbdPxV1gcrsSiNmVG-sw_at_mail.gmail.com>



Hi Experts,
I compared reports of both tests and found that *DB File Parallel Write*simply does not appear in the test which had high undo writes. This is
inspite of the workload being exactly the same. Host statistics for both tests show the same amount (wkb/s) of data written.

Another observation is that *data blocks consistent reads - undo records applied* is very low in the test with high undo writes wheras it very high in the test with low undo writes.

Thanks.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 21 2012 - 04:33:22 CDT

Original text of this message