Re: PGA Memory Leak - crashing Server

Greetings

Its a sort of connection pooling implemented by app.

App opens connections to the database, and keeps them open to service the requests.

We have never flushed the shared_pool, We didn't think they are connected and we didn't see any issues towards SP .

Servers got rebooted for running out of Memory because of this issue, in that process
DB got restarted.

BN

On 9/19/07, Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com> wrote:
>
> 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
>
>
>
> one question here. You mean by "connections are always here", that the
> problematic connections are long-lived or something? have you restarted the
> instance or flushed the shared pool
>
> since the problem started?
>
>
>
>
>
> We submitted all the 10046 Level 12 trace files to SR, they came back with
> nothing.
>
>
>
> One thing. are you using OEM/db control or AWR (I'm sorry I'm on 9i yet),
> and maybe you could extract from here some info about the sessions' PGA
> usage, which are accelerating the leakage?
>
>
>
>
>
> thats why I am looking for ideas to
>
>
>
> where to look and ways to reproduce the issues.
>
>
>
> BN
>
>

-- 
Regards & Thanks
BN

--
http://www.freelists.org/webpage/oracle-l