Re: batch process runs slower and slower over time
- From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Thu, 7 Jun 2012 21:15:58 +0300
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@xxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
