Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PGA Memory Leak - crashing Server

Re: PGA Memory Leak - crashing Server

From: BN <bnsarma_at_gmail.com>
Date: Wed, 19 Sep 2007 17:30:59 -0400
Message-ID: <61292a9d0709191430o6e8f7400t46cf48fda9acf051@mail.gmail.com>


Greetings

I took 10046 Level 12 trace of all the Problem Processes, we see nothing that can cause this.

I don't see any SQL, Package/proc accessing huge amount of data in the tkprofd output.
The MAx number of rows touched is around 100k (10519)

Sicne these connections are always there, I wouldn't know if I have missed the real issue,
But I did trace 5 sessions and none of them have any thing thats noticable

We submitted all the 10046 Level 12 trace files to SR, they came back with nothing.

thats why I am looking for ideas to

where to look and ways to reproduce the issues.

BN

On 9/19/07, Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com> wrote:
>
> Hello Bn,
>
>
>
> 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.
>
>
>
> similar load? well, but the generated plan for the query (in the package),
> is the same in DEV as in prod?
>
>
>
> 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.
>
>
>
> , yeah, but, does it generate the same optimizer plan in both db's?
>
>
>
> Any Ideas and suggestions are appreciated
>
>
>
> put the plan in Prod here (look in v$sql_plan and v$sql_plan_statistics,
> for the "hash" value of the problematic query (if it is localized in 1
> query)
>
>
>
> Regards
>
> BN
>
>
>
>
>
> --
> Regards & Thanks
> BN
>

-- 
Regards & Thanks
BN

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 19 2007 - 16:30:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US