Re: batch process runs slower and slower over time
From: Ls Cheng <exriscer_at_gmail.com>
Date: Thu, 17 May 2012 22:22:16 +0200
Message-ID: <CAJ2-Qb_sjnvheEk+dP3-=Rn6KsTr9-7yGz_YeTSsgoajJZJHqw_at_mail.gmail.com>
Hi
From session statistics which we capture for each customer consistent gets is not increasing over time, data blocks consistent reads - undo records applied is very small (10 to 20), CR blocks created is small as well so i dont think I am hitting undo very often
Date: Thu, 17 May 2012 22:22:16 +0200
Message-ID: <CAJ2-Qb_sjnvheEk+dP3-=Rn6KsTr9-7yGz_YeTSsgoajJZJHqw_at_mail.gmail.com>
Hi
From session statistics which we capture for each customer consistent gets is not increasing over time, data blocks consistent reads - undo records applied is very small (10 to 20), CR blocks created is small as well so i dont think I am hitting undo very often
Thanks!
--
LSC
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 17 2012 - 15:22:16 CDT