RE: PGA Memory Leak - crashing Server

  • From: "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
  • To: "BN" <bnsarma@xxxxxxxxx>
  • Date: Thu, 20 Sep 2007 00:30:11 +0200

Hi Sarma,


What is puzzling me about the problem, is that if you have DEV with the
same configured parameters, system statistics, and with a similar load
(tables), the faulty code don't reproduce the problem on DEV. 

Apart from the bug cited, subtle plan variations (discarded as per you
investigation), and other hidden things, honestly I can only now


-          to "load" DEV with the most similar load as prod, and submit
at "representative" number of connections. 

-          thorougly check DEV kernel settings (compare the output of a
"sysdef"  on both HP-UX machines). Compare also the output of a glance
or "top" for similar stack/resident memory usage for the processes
involved in the "faulty" code. Check differences also at the HP-UX level
between DEV and prod . 



Other related posts: