Re: strange wait events

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
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-l
Received on Thu Feb 02 2023 - 17:13:31 CET

Original text of this message