RE: batch process runs slower and slower over time
Date: Thu, 7 Jun 2012 16:57:10 -0400
Message-ID: <03bb01cd44f0$1c52f150$54f8d3f0$_at_rsiz.com>
Nods. If the head count of jobs with different sources exceeds the ability of staff to easily convert them given a decent go-by, then you'll need to find the root cause. And each separate such job needs to be scrutinized for whether concurrency issues demand it be run head to tail rather than in parallel.
I suspect such jobs being re-written with parallelizable ranges would be a good overall improvement to the systems. It is the type of thing we always had to do when the machines were slower.
Are you able to transplant the work load to a very recent release of Oracle RDBMS as a test to see if the problem just goes away? If so, then data mining bug fix reports *might* be a more efficient solution.
Not that finding out the root cause by tracing won't be a satisfying thing to do. I just wonder whether upon finding the root cause it is going to be that there is a bug that is un-patched and not likely to be back-ported to 10.x so you'll be left with the problem until you can upgrade.
Making processing less demanding of the Oracle engine is a valid pursuit. Maybe picking these off one at a time is the effective route, maybe not.
Regards,
mwf
From: Ls Cheng [mailto:exriscer_at_gmail.com]
Sent: Thursday, June 07, 2012 4:03 PM
To: mwf_at_rsiz.com
Cc: Oracle Mailinglist
Subject: Re: batch process runs slower and slower over time
Hi
Yes probably changing the way this process is run we can get the objective but seems like there are more processes suffering same issue so now we are looking into finding the root cause.
I have applied a couple of patches which deals with performance degredation and memory leak in 10.2.0.5 without success, tried some truss without success neither
dbms_profiler gives funny results, wonder if it's working
Next tests will be running 10046 for 1000 and 2000 customers and probably mix with Tanel dtrace script however I doubt I can use it because last time I ran dtrace root privileges was requiered
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 07 2012 - 15:57:10 CDT