Re: strange wait events
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Sat, 11 Feb 2023 10:24:27 +0000
Message-ID: <CAGtsp8=TXvuuh8ULo38O_E1u=A_EGYR=QGBb5UKMnfHnHu-JKQ_at_mail.gmail.com>
Date: Sat, 11 Feb 2023 10:24:27 +0000
Message-ID: <CAGtsp8=TXvuuh8ULo38O_E1u=A_EGYR=QGBb5UKMnfHnHu-JKQ_at_mail.gmail.com>
Have you got any further finding out where your strange wait events are
coming from ?
Regards
On Thu, 2 Feb 2023 at 16:03, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
wrote:
> Dear oracle community,
Jonathan Lewis
>
> 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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 11 2023 - 11:24:27 CET