Re: ORA-04031 and EM Express 12c

From: Tanel Poder <>
Date: Fri, 17 May 2019 17:23:03 -0400
Message-ID: <>

Probably just a bunch of UGA usage in process private memory still managed by pga_aggregate_target ... I’ve never looked into whether EM Express can be configured to use dedicated servers somehow (as due to XDB web server they essentially have to stay around like daemons and listen on the port 5500 or something, haven’t checked details, but that may be the reason for using shared server processes).

But I’ve had to change the max_servers higher to make EM Express faster to load & use...

Tanel Poder

On Wed, May 15, 2019 at 22:16 Mladen Gogala <> wrote:

> I wonder what would happen if pooled connections were used, instead of
> shared server ones.
> Regards
> On 5/15/19 8:54 PM, Tanel Poder wrote:
> > 5) And since in your case, with shared servers, the cursor-duration
> > "private memory" is actually kept in large pool, you have this large
> > allocation.
> --
Sent from mobile

Received on Fri May 17 2019 - 23:23:03 CEST

Original text of this message