PGA on higher version
From: Pap <oracle.developer35_at_gmail.com>
Date: Wed, 19 May 2021 02:29:30 +0530
Message-ID: <CAEjw_fgAP=gC2oGEtPLJWaLPrgSRcCDqbO5r5hSrqDEc0KSeZg_at_mail.gmail.com>
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?
Date: Wed, 19 May 2021 02:29:30 +0530
Message-ID: <CAEjw_fgAP=gC2oGEtPLJWaLPrgSRcCDqbO5r5hSrqDEc0KSeZg_at_mail.gmail.com>
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-lReceived on Tue May 18 2021 - 22:59:30 CEST