Re: Tuning EBS 19c in CDB/PDB architecture

From what I recall the EBS PDB conversion sets the required parameters at the CDB level and they are inherited by the PDB. If for some reason the values have been set at the PDB level, it’s probably a good idea to reset them in the PDB to inherit the CDB values - particularly to avoid issues when cloning. On 5 May 2022, 9:24 AM +1000, Bala <oratips_at_gmail.com>, wrote:
> 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