Re: Oracles network logging

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Tue, 30 Jul 2013 08:13:10 -0600
Message-ID: <51F7C9F6.2030304_at_gmail.com>

I would try switching back to SGA Mem management instead of Total Mem management as a test.

The OS can be one of the constraining factors for thread creation rate. One of my customers is rewriting an app that attempts very high rates of connections because of that, so it might be a similar issue for you.

/Hans

On 30/07/2013 7:33 AM, Joel Slowik wrote:
> Hi Hans,
>
> Thanks for this input. I like your thoughts particularly on 12518/12564. This system was recently (few months back) upgraded to a new server and now has 18 gbs for pga and sga (we're using memory_target and memory_max_target) whereas the old server only had 3gb in total to work with, IIRC 50mb for pga; they never reported this issue on the old server. Still, perhaps the connections are happening so fast that the memory is still a bottleneck, I'll review.
>
> Thanks,
> -joel
>

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

Received on Tue Jul 30 2013 - 16:13:10 CEST