Re: Tuning EBS 19c in CDB/PDB architecture

Thank you very much Mark.

Yes we are bumping our SGA_TARGET and PGA_AGGREGATE_TARGET at CDB level -- should we do anything to make it "0" at PDB level or anything ? so that previously set (prior to becoming a PDB) less value is not used at all ? Yes, will check on pga_aggregate_limit usage. Thanks again

On Wed, May 4, 2022 at 7:12 PM Mark Burgess <mark_at_burgess-consulting.com.au> wrote:

> Hi Bala,
>
> no specific changes - just make sure that all the patches are applied as
> per the MOS notes for DB, FMW and EBS and all settings as per the release
> specific init params are in place. If pga_aggregate_target has been
> increased during the upgrade process it might be worth keeping an eye on
> pga_aggregate_limit usage.
>
> Regards,
>
> Mark
> On 5 May 2022, 8:17 AM +1000, Bala <oratips_at_gmail.com>, wrote:
>
> Gurus,
>
> Any pointers to tune EBS 19c (19.14) database in CDB with one pdb
> architecture ?
> We upgraded from existing 12.1.0.2 database
>
> Request some clarity on where you adjust and tune parameters like
> sga_target etc ? -- do we set anything specific for a PDB ?
>
> Thank you for your time.
> --
> Bala Rao
>
>

-- 
Bala Rao

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