Re: PGA on higher version

Below does point to the fact that recent Oracle versions need higher PGA. But i would say , do check v$process_memory to see if any one odd sql is causing this. What are the pga parameters set?

Limiting Process Size with Database Parameter PGA_AGGREGATE_LIMIT (Doc ID 1520324.1)

Regards
Lok

On Wed, May 19, 2021 at 2:30 AM Pap <oracle.developer35_at_gmail.com> wrote:

> We are seeing higher pga_allocated post 19C migration. Experienced
> Ora-04030 already post migration in many cases.So trying to understand if
> there is any change in behaviour as compared to 11.2.0.4? And how should we
> debug and estimate the correct value here?
>
> ORA-04030: out of process memory when trying to allocate 248 bytes (KSIPC
> Top Loca,ksipc pga chnk)
>
> Regards
> Pap
>

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