Re: strange wait events
Date: Thu, 2 Feb 2023 16:13:31 +0000
Message-ID: <CAOVevU7x9RfXCu=9+CsETYRWiHWJTH0xrDZ3uC2PHttkHbnL=Q_at_mail.gmail.com>
Hi Laurentiu,
JS - Job Scheduler
KGL - kernel generic library
So you need to check blocking sessions and what objects the job scheduler
is trying to get/pin.
On Thu, Feb 2, 2023 at 4:03 PM Laurentiu Oprea <laurentiu.oprea06_at_gmail.com> wrote:
> Dear oracle community,
>
> I`m running some tests on 19.17 DB (rac and non-rac - data and data
> structures are absolutely identical).
>
> In the RAC DB I see that an updated generated by a triggered
> significantly slower compared with single instance and top wait events are:
> 65% JS kgl get object wait
> 11% reliable messages
> 8% library cache pin
> 5% CPU
>
> Anyone have any idea what JS kgl get object wait event is and how can I
> diagnose the cause for it?
>
> THank you in advance.
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 02 2023 - 17:13:31 CET
