Re: batch process runs slower and slower over time

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 7 Jun 2012 21:15:58 +0300
Message-ID: <CAMHX9JLH-57BOzNzpZ--Gh2dLwFLHkuGRO8msq5drVRWTZP5Lg_at_mail.gmail.com>

So are you putting these metrics into context of amount work done (as your throughput gets worse over time) or just looking into per second numbers? E.g. divide these sesstat metrics by "user commits" or "execute count". The amount of LIOs you can do per second remains roughly the same over time (despite the varying cost of a LIO depending on how much data you access in the block) as long as your CPUs keep running at the same speed. Tanel

On Thu, May 17, 2012 at 11:22 PM, Ls Cheng <exriscer_at_gmail.com> wrote:

> 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
>
>
>

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

Received on Thu Jun 07 2012 - 13:15:58 CDT