Hi Folks
We are frequently coming across oracle latch contention issues when the application related to procedure is running in parallel using DBMS_SCHEDULER.
I did an extensive research to find an option to avoid it, but there are more option for DBAs to fix it.
Being a Oracle developer, I would like to know what are the best practices, possible ways and suggestions to make changes to the program to handle the latch contention.
From what I read using bind variables and sharing the cursor are the option I have in hand to try.
Any more suggestion is highly appreciated. Thanks !!