Re: ORA-04031 and EM Express 12c
From: Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
Date: Mon, 13 May 2019 14:21:57 -0400
Message-Id: <5CD9B5C50200000B00058B89_at_groupwise2014.gcrta.org>
Date: Mon, 13 May 2019 14:21:57 -0400
Message-Id: <5CD9B5C50200000B00058B89_at_groupwise2014.gcrta.org>
How large did you make your shared pool?
>>> Mladen Gogala <gogala.mladen_at_gmail.com> 5/13/19 2:16 PM >>>
Hi Alessandro,
This is a strange error and refers to the large pool. Large pool is usually used for backup and things like GG. Your trace file doesn't show the SQL. I would call Oracle support and try flushing the shared pool as a palliative measure.
Regards
On 5/13/19 10:33 AM, Alessandro Vercelli (Redacted sender alever22 for
DMARC) wrote:
> I tried to increase values for
> shared_pool_size/shared_pool_reserved_size, sga_target but no success
>
> Thanks for your time and suggestions
>
> Alessandro
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 13 2019 - 20:21:57 CEST