Re: strange wait events

Thank you very much for all the suggestions.

After all, I traced everything in the DB. There were a lot of triggers involved, but one of them was firing for every action on a table, a procedure which was dropping and recreating a job. This had a significantly bigger impact in RAC vs single Instance and explained the significant JS kgl get object wait

What was strange was that there was a small percentage in the wait events about result cache (and the query for checking reliable messages had the biggest numbers for a result cache component) but I didn't find any result cache hint, probably there is a built-in feature in pl/sql about result cache ... not aware of this.

Thank all again for all the help

În sâm., 11 feb. 2023 la 12:25, Jonathan Lewis <jlewisoracle_at_gmail.com> a scris:

>
> Have you got any further finding out where your strange wait events are
> coming from ?
>
> Regards
> Jonathan Lewis
>
>
> On Thu, 2 Feb 2023 at 16:03, 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.
>>
>

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