RE: batch process runs slower and slower over time
Date: Thu, 17 May 2012 16:17:25 -0400
Message-ID: <2F161F8A09B99B4ABF8AE832D546E7890ED9C766DB_at_us194mx002.tycoelectronics.net>
Is there any chance you are reading from the undo tablespace more frequently as this process progresses? We have seen major slow downs developing as a result of consistent reads that have to reach into the undo tablespace for records that have been updated...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ls Cheng
Sent: Thursday, May 17, 2012 3:37 PM
To: Toon Koppelaars
Cc: Oracle Mailinglist
Subject: Re: batch process runs slower and slower over time
Hi
I took PGA heapdumps and also monitored PGA during execution.
PGA was increasing and decreasing all the time (but always end up increasing a bit), the process started with like 20MB PGA allocated, after 12 hours it had 150MB allocated.
Let me check the memory leak issues in this version and see if we have some potential bug and check the PL/SQL code and see if the arrays are being used properly
Thanks
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 17 2012 - 15:17:25 CDT