Re: Odd wait event freezing database
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Wed, 5 May 2021 13:48:16 -0400
Message-ID: <CAMHX9JJiVnWVUY_Z8PEDT6LixhP+S8W3EnfjUBwVcn6h_8DXWA_at_mail.gmail.com>
Date: Wed, 5 May 2021 13:48:16 -0400
Message-ID: <CAMHX9JJiVnWVUY_Z8PEDT6LixhP+S8W3EnfjUBwVcn6h_8DXWA_at_mail.gmail.com>
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_at_linux03 (DBW0)
SQL>
SQL> oradebug setorapname *pmon*
Oracle pid: 2, Unix process pid: 5490, image: oracle_at_linux03 (PMON)
SQL>
-- Tanel Poder https://tanelpoder.com/eventsReceived on Wed May 05 2021 - 19:48:16 CEST
> 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.
>
>>
>>>>>>>>
-- http://www.freelists.org/webpage/oracle-l