DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=M1DtUJmsO8OXX7/AvkRlKtVrJYn+NdlfIhrYdTyInyPmVuqD/xPIZ/qztDusqL/y07EJxI6+IVykW0FF+J7IHCuTv+LbKebT2DyXpq34nj2C1a27mGWIDmMiMzqG+K51u9PZEh2Oc1pf1z0BX7R/C8iKRxpBFk4D4kvDhO+Kup4=
Message-ID: <6e9345580709191450g72e7d9c8kc3b4bcdb178ed872@mail.gmail.com>
Date: Wed, 19 Sep 2007 23:50:34 +0200
From: "LS Cheng" <exriscer@gmail.com>
To: bnsarma@gmail.com
Subject: Re: PGA Memory Leak - crashing Server
Cc: oracle_L_list <oracle-l@freelists.org>
In-Reply-To: <61292a9d0709191313t159d13bfo20b3fa136390b442@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_11203_23032164.1190238634524"
References: <61292a9d0709191313t159d13bfo20b3fa136390b442@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: exriscer@gmail.com
------=_Part_11203_23032164.1190238634524
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

Do you know what is the simple change? Also do you see any ORA- error?

Thanks

--
LSC


On 9/19/07, BN <bnsarma@gmail.com> wrote:
>
> Greetings
>
> HP-UX 11.11, 4X4 Server
>
>
>
> Oracle version:
>
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
> PL/SQL Release 10.2.0.1.0 - Production
> CORE    10.2.0.1.0      Production
> TNS for HPUX: Version 10.2.0.1.0 - Production
> NLSRTL Version 10.2.0.1.0 - Production
>
>
> PARAMETER                 VALUE
> ------------------------- ---------------
> _pga_large_extent_size    1048576
> _pga_max_size             209715200
>
> pga_aggregate_target                 big integer 100M
>
>
> We do see warnigns in AWR reports  to bump pga. we haven't done that.
> Could smaller pga cause this memory leak?
>
>
> We started with this version, plans are there to go to the Latest Patch
> Set. But for now we are stuck with this
>
> DEV folks did a release last Friday, its a simple change in  a package
>
> Problem:
>
> One process at a time goes upto  715 MB
> anothher process starts goes up to 715 MB
> another process start goes upto 715 MB
> . . . . . .
>
> Until system Crashes
>
> We Backeduout the code, we are back to normal.
>
> We have almost simialr load in one of our DEV server (4X4), We tried same
> code, we are not able to reproduce the issue.
>
> Only other option for us is to disable PGA and go for manual memory
> allocation by define sort_* values
>
> We have an SR open, we gave all the dumps oralce asked before we backed
> out the code in prod.
> Now oracle wants HEAP dumps, but managment doesn't want this  faulty code
> in prod until we fix the issue.
>
> The same code works fine in DEV. Server.
>
> Any Ideas and suggestions are appreciated
>
> Regards
> BN
>
>
>
> --
> Regards & Thanks
> BN
>

------=_Part_11203_23032164.1190238634524
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi</div>
<div>&nbsp;</div>
<div>Do you know what is the simple change? Also do you see any ORA- error?</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>&nbsp;</div>
<div>--</div>
<div>LSC</div>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 9/19/07, <b class="gmail_sendername">BN</b> &lt;<a href="mailto:bnsarma@gmail.com">bnsarma@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Greetings</div>
<div>&nbsp;</div>
<div>HP-UX 11.11, 4X4 Server</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Oracle version:</div>
<div>&nbsp;</div>
<div>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi<br>PL/SQL Release 10.2.0.1.0 - Production<br>CORE&nbsp;&nbsp;&nbsp; 10.2.0.1.0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Production<br>TNS for HPUX: Version 10.2.0.1.0 - Production<br>NLSRTL Version 10.2.0.1.0
 - Production<br>&nbsp;</div>
<div>&nbsp;</div>
<div>PARAMETER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE<br>------------------------- ---------------<br>_pga_large_extent_size&nbsp;&nbsp;&nbsp; 1048576<br>_pga_max_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 209715200<br>&nbsp;</div>
<div>pga_aggregate_target&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; big integer 100M</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>We do see warnigns in AWR reports&nbsp; to bump pga. we haven&#39;t done that. </div>
<div>Could smaller pga cause this memory leak?</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>We started with this version, plans are there to go to the Latest Patch Set. But for now we are stuck with this</div>
<div>&nbsp;</div>
<div>DEV folks did a release last Friday, its a simple change in&nbsp; a package</div>
<div>&nbsp;</div>
<div>Problem:</div>
<div>&nbsp;</div>
<div>One process at a time goes upto&nbsp; 715 MB</div>
<div>anothher process starts goes up to 715 MB</div>
<div>another process start goes upto 715 MB</div>
<div>. . . . . .</div>
<div>&nbsp;</div>
<div>Until system Crashes</div>
<div>&nbsp;</div>
<div>We Backeduout the code, we are back to normal.</div>
<div>&nbsp;</div>
<div>We have almost simialr load in one of our DEV server (4X4), We tried same code, we are not able to reproduce the issue.</div>
<div>&nbsp;</div>
<div>Only other option for us is to disable PGA and go for manual memory allocation by define sort_* values</div>
<div>&nbsp;</div>
<div>We have an SR open, we gave all the dumps oralce asked before we backed out the code in prod.</div>
<div>Now oracle wants HEAP dumps, but managment doesn&#39;t want this&nbsp; faulty code in prod until we fix the issue.</div>
<div>&nbsp;</div>
<div>The same code works fine in DEV. Server.</div>
<div>&nbsp;</div>
<div>Any Ideas and suggestions are appreciated</div>
<div>&nbsp;</div>
<div>Regards</div>
<div>BN</div>
<div>&nbsp;</div>
<div><br clear="all"><br>-- <br>Regards &amp; Thanks<br>BN </div></blockquote></div><br>

------=_Part_11203_23032164.1190238634524--
--
http://www.freelists.org/webpage/oracle-l