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@xxxxxxxxx> 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@xxxxxxxxx>
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.
