RE: batch process runs slower and slower over time
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: "'Ls Cheng'" <exriscer@xxxxxxxxx>
- Date: Thu, 7 Jun 2012 16:57:10 -0400
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@xxxxxxxxx]
Sent: Thursday, June 07, 2012 4:03 PM
To: mwf@xxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
