MIME-Version: 1.0
References: <CAKna9VaY4KFu6RFfHYnRZ4t69Ct4J2itLSejGFG-rMrgNv=Z1A@mail.gmail.com>
 <CAGtsp8n_PWgLqx3KyC0XWMvT9ycBPaOJkC7+dR0iqtOXnmgoog@mail.gmail.com>
 <CAKna9Va8KABsZ8o0VqRcLPgZi9KyJxmJ4y9+Dr5azrr_ru7YdQ@mail.gmail.com>
 <CAKna9VZ5sgJ-iejaL_7Zbt5pHsK-V8JYu6r=1pnDy_Pm-6yB6g@mail.gmail.com>
 <CAKna9VZMae63jKU2B9TpSsgfMqbipWbR_fGbcVMb_ZJZob59Gg@mail.gmail.com>
 <CAKna9VaCuMGG=VmjwyvzF_JX6m-Oq99MvdpYTD=zW5aWveR+bA@mail.gmail.com>
 <CAKna9VZYXemkaX2d13VoK-1MsXakw5BnJWHiMak-1_bUfVTfEA@mail.gmail.com>
 <CAKna9Va4WDt+jTnpsqhfDsEWJhFqXK6xq=iZS=kBSqVxzFEwWw@mail.gmail.com>
 <CAGtsp8k1Yx8JJ4--3OxZ-sUZN+8DJrtVFBEjUCwbi6MhXfKgNw@mail.gmail.com>
 <CAKna9Va4vSSoLjg=oVaTUpxEL+XVCPvWoFhtRZfi-gpA8B8Tug@mail.gmail.com>
 <CAKna9VbKg1eEPEGM3HzpreUVWpi5JAnKCLSQosA=VEb3fdgdJg@mail.gmail.com> <CAGtsp8mjcWN65v4jtRWSziiBRg0-aeU3OgeyCWBrsGSC0Lw1Og@mail.gmail.com>
In-Reply-To: <CAGtsp8mjcWN65v4jtRWSziiBRg0-aeU3OgeyCWBrsGSC0Lw1Og@mail.gmail.com>
From: Tanel Poder <tanel@tanelpoder.com>
Date: Wed, 5 May 2021 13:48:16 -0400
Message-ID: <CAMHX9JJiVnWVUY_Z8PEDT6LixhP+S8W3EnfjUBwVcn6h_8DXWA@mail.gmail.com>
Subject: Re: Odd wait event freezing database
To: Jonathan Lewis <jlewisoracle@gmail.com>
Cc: Lok P <loknath.73@gmail.com>, Oracle L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="0000000000004ecc6605c198cd1c"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: tanel@tanelpoder.com
--0000000000004ecc6605c198cd1c
Content-Type: text/plain; charset="UTF-8"

Since 11g there's also an oradebug *setorapname* command for attaching to
background processes by their name:

SQL> oradebug setorapname *dbw0*
Oracle pid: 9, Unix process pid: 5506, image: oracle@linux03 (DBW0)
SQL>
SQL> oradebug setorapname *pmon*
Oracle pid: 2, Unix process pid: 5490, image: oracle@linux03 (PMON)
SQL>

--
Tanel Poder
https://tanelpoder.com/events


> oradebug setospid {os process id for ctwr}
> oradebug event 10046 trace name context forever, level 8
>
> (you could also use "osdebug setorapid {v$process.pid for ctwr}" instead
> of setospid.
>
>>
>>>>>>>>

--0000000000004ecc6605c198cd1c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_quote"><div>Since 11g=
 there&#39;s also an oradebug <b>setorapname</b> command for attaching=C2=
=A0to background processes by their name:</div><div><pre style=3D"padding-l=
eft:1em;padding-top:1em;padding-bottom:1em;overflow-x:auto;line-height:1.5e=
m;font-family:&quot;Courier New&quot;,&quot;Lucida Console&quot;,Monaco,mon=
ospace;font-size:15px;width:1000px;color:rgb(0,0,0)">SQL&gt; oradebug setor=
apname <b>dbw0</b>
Oracle pid: 9, Unix process pid: 5506, image: oracle@linux03 (DBW0)
SQL&gt;
SQL&gt; oradebug setorapname <b>pmon</b>
Oracle pid: 2, Unix process pid: 5490, image: oracle@linux03 (PMON)
SQL&gt;
</pre>--</div><div>Tanel Poder</div><div><a href=3D"https://tanelpoder.com/=
events">https://tanelpoder.com/events</a></div><div><br></div><div>=C2=A0</=
div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,20=
4);padding-left:1ex"><div dir=3D"ltr"><div></div><div>oradebug setospid {os=
 process id for ctwr}</div><div>oradebug event 10046 trace name context for=
ever, level 8</div><div><br></div><div>(you could also use &quot;osdebug se=
torapid {v$process.pid for ctwr}&quot; instead of setospid.</div></div><div=
 class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-c=
olor:rgb(204,204,204);padding-left:1ex"><div class=3D"gmail_quote"><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-wid=
th:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-l=
eft:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-=
left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div =
dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:sol=
id;border-left-color:rgb(204,204,204);padding-left:1ex"><div class=3D"gmail=
_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,20=
4,204);padding-left:1ex"><div class=3D"gmail_quote"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-l=
eft-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div c=
lass=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-col=
or:rgb(204,204,204);padding-left:1ex"><br></blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div></div>
</blockquote></div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div></div></div>

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