Re: High Number of undo writes
- From: Purav Chovatia <puravc@xxxxxxxxx>
- To: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- Date: Mon, 21 May 2012 15:03:22 +0530
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
