Re: batch process runs slower and slower over time

From: Ls Cheng <exriscer_at_gmail.com>
Date: Thu, 17 May 2012 21:37:26 +0200
Message-ID: <CAJ2-Qb-pkg2AYunDL5w+QOiXh7Sqe+tP6eyukUj1K6Hak18owg_at_mail.gmail.com>



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
Received on Thu May 17 2012 - 14:37:26 CDT

Original text of this message