Re: batch process runs slower and slower over time
From: Ls Cheng <exriscer_at_gmail.com>
Date: Thu, 7 Jun 2012 21:49:59 +0200
Message-ID: <CAJ2-Qb_OWGm8kXf0zy5D4ey97Lm95Wb=iF-W6BBNw5kwFY3V8w_at_mail.gmail.com>
Hi
I am not looking into per second, rather the amount of work done per business transaction.
Date: Thu, 7 Jun 2012 21:49:59 +0200
Message-ID: <CAJ2-Qb_OWGm8kXf0zy5D4ey97Lm95Wb=iF-W6BBNw5kwFY3V8w_at_mail.gmail.com>
Hi
I am not looking into per second, rather the amount of work done per business transaction.
for each transaction I capture sesstat and session_wait, then use an analytic query to get the deltas
but bullets are running out :-)
thanks!
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 07 2012 - 14:49:59 CDT