Re: Runaway pl/sql in the db from orphaned oas connections causes complete memory saturation
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 7 Dec 2012 06:34:31 +0000
Message-ID: <CABe10sbWzsOm+LLsteUmirrj05cEWic7=gjEuJCzSDMgf6YvcQ_at_mail.gmail.com>
I don't think anyone here will be able to see the SRs - but if you can share the Hello World test case...
Date: Fri, 7 Dec 2012 06:34:31 +0000
Message-ID: <CABe10sbWzsOm+LLsteUmirrj05cEWic7=gjEuJCzSDMgf6YvcQ_at_mail.gmail.com>
I don't think anyone here will be able to see the SRs - but if you can share the Hello World test case...
On Fri, Dec 7, 2012 at 3:08 AM, Charles Schultz <sacrophyte_at_gmail.com>wrote:
> Good day,
> I am hoping that some kind soul who is uber awesome at tracking down pl/sql
> and PGA issues will be able to help us out on this one. :)
>
> We managed to accumulate 3 open SRs on this problem:
>
> - SR 3-6456891351 : Hemorrhaging Memory
> - SR 3-6496145406 : KV: OHS/mod_plsql Connection Keeps Growing and
> Causes DB to Become Unresponsive /* this one has the most detail */
> - SR 3-6532544331 : Customer getting ORA-2730x errors
>
>
>
>
> --
> Charles Schultz
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 07 2012 - 07:34:31 CET