Date: Thu, 5 May 2022 09:45:51 +1000
From: "Mark Burgess" <dmarc-noreply@freelists.org> ("mark")
To: Bala <oratips@gmail.com>
Cc: oracle-l <oracle-l@freelists.org>
Message-ID: <1392f5f6-768b-4ad5-b712-4eccbde84ec8@Spark>
In-Reply-To: <CAF5SaXvH1=McasOVY1jTTj=FJQ8f2UFJ01MY_o+oOcwL7BHaWg@mail.gmail.com>
References: <CAF5SaXs-ys3+2tNq=aZ=8Qu7DuCgcKBBhc8V_c-f-NEVNJbFcQ@mail.gmail.com>
 <0457dac6-db8e-46fc-875d-1bfc14c37495@Spark>
 <CAF5SaXvH1=McasOVY1jTTj=FJQ8f2UFJ01MY_o+oOcwL7BHaWg@mail.gmail.com>
Subject: Re: Tuning EBS 19c in CDB/PDB architecture
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="62731034_8138641_c105"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: mark@burgess-consulting.com.au
--62731034_8138641_c105
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=46rom 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 th=
e values have been set at the PDB level, it=E2=80=99s probably a good ide=
a to reset them in the PDB to inherit the CDB values - particularly to av=
oid issues when cloning.
On 5 May 2022, 9:24 AM +1000, Bala <oratips=40gmail.com>, wrote:
> Thank you very much Mark.
>
> Yes we are bumping our SGA=5FTARGET and PGA=5FAGGREGATE=5FTARGET at CDB=
 level -- should we do anything to make it =220=22 at PDB level or anythi=
ng =3F so that previously set (prior to becoming a PDB) less value is not=
 used at all =3F
> Yes, will check on pga=5Faggregate=5Flimit usage.
> Thanks again
>
> > On Wed, May 4, 2022 at 7:12 PM Mark Burgess <mark=40burgess-consultin=
g.com.au> wrote:
> > > Hi Bala,
> > >
> > > no specific changes - just make sure that all the patches are appli=
ed as per the MOS notes for DB, =46MW and EBS and all settings as per the=
 release specific init params are in place. If pga=5Faggregate=5Ftarget h=
as been increased during the upgrade process it might be worth keeping an=
 eye on pga=5Faggregate=5Flimit usage.
> > >
> > > Regards,
> > >
> > > Mark
> > > On 5 May 2022, 8:17 AM +1000, Bala <oratips=40gmail.com>, wrote:
> > > > Gurus,
> > > >
> > > > Any pointers to tune EBS 19c (19.14) database in CDB with one pdb=
 architecture =3F
> > > > We upgraded from existing 12.1.0.2 database
> > > >
> > > > Request some clarity on where you adjust and tune parameters like=
 sga=5Ftarget etc =3F -- do we set anything specific for a PDB =3F
> > > >
> > > > Thank you for your time.
> > > > --
> > > > Bala Rao
>
>
> --
> Bala Rao

--62731034_8138641_c105
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<html xmlns=3D=22http://www.w3.org/1999/xhtml=22>
<head>
<title></title>
</head>
<body>
<div name=3D=22messageBodySection=22>
<div dir=3D=22auto=22>=46rom what I recall the EBS PDB conversion sets th=
e 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=E2=80=99=
s probably a good idea to reset them in the PDB to inherit the CDB values=
 - particularly to avoid issues when cloning.</div>
</div>
<div name=3D=22messageReplySection=22>On 5 May 2022, 9:24 AM +1000, Bala =
&lt;oratips=40gmail.com&gt;, wrote:<br />
<blockquote type=3D=22cite=22 style=3D=22border-left-color: grey; border-=
left-width: thin; border-left-style: solid; margin: 5px 5px;padding-left:=
 10px;=22>
<div dir=3D=22ltr=22>
<div dir=3D=22ltr=22>Thank you very much Mark.
<div><br /></div>
<div>Yes we are bumping our SGA=5FTARGET and PGA=5FAGGREGATE=5FTARGET at =
CDB level -- should we do anything to make it =220=22 at PDB level or any=
thing =3F so that previously set (prior to becoming a PDB) less value is =
not used at all =3F</div>
<div>Yes, will check on pga=5Faggregate=5Flimit usage.</div>
<div>Thanks again<br /></div>
</div>
<br />
<div class=3D=22gmail=5Fquote=22>
<div dir=3D=22ltr=22 class=3D=22gmail=5Fattr=22>On Wed, May 4, 2022 at 7:=
12 PM Mark Burgess &lt;<a href=3D=22mailto:mark=40burgess-consulting.com.=
au=22>mark=40burgess-consulting.com.au</a>&gt; wrote:<br /></div>
<blockquote class=3D=22gmail=5Fquote=22 style=3D=22margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=22>
<div>
<div name=3D=22messageBodySection=22>
<div dir=3D=22auto=22>Hi Bala,<br />
<br />
no specific changes - just make sure that all the patches are applied as =
per the MOS notes for DB, =46MW and EBS and all settings as per the relea=
se specific init params are in place. If pga=5Faggregate=5Ftarget has bee=
n increased during the upgrade process it might be worth keeping an eye o=
n pga=5Faggregate=5Flimit usage.&=23160;<br />
<br />
Regards,<br />
<br />
Mark</div>
</div>
<div name=3D=22messageReplySection=22>On 5 May 2022, 8:17 AM +1000, Bala =
&lt;<a href=3D=22mailto:oratips=40gmail.com=22 target=3D=22=5Fblank=22>or=
atips=40gmail.com</a>&gt;, wrote:<br />
<blockquote type=3D=22cite=22 style=3D=22border-left:thin solid grey;marg=
in:5px;padding-left:10px=22>
<div dir=3D=22ltr=22>
<div>Gurus,</div>
<div><br /></div>
Any pointers to tune EBS 19c (19.14) database in CDB with one pdb archite=
cture =3F
<div>We upgraded from existing 12.1.0.2 database</div>
<div><br /></div>
<div>Request some clarity on where you adjust and tune parameters like sg=
a=5Ftarget etc =3F -- do we set anything specific for a PDB =3F<br clear=3D=
=22all=22 />
<div><br /></div>
<div>Thank you for your time.</div>
--<br />
<div dir=3D=22ltr=22>Bala Rao</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
<br clear=3D=22all=22 />
<div><br /></div>
--<br />
<div dir=3D=22ltr=22 class=3D=22gmail=5Fsignature=22>Bala Rao</div>
</div>
</blockquote>
</div>
</body>
</html>

--62731034_8138641_c105--

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