Re: Error 4009
Hi Nisa
Without more information it is hard to say anything of slow queries except the general stuff as:
* it is a big query, even if it has a small result set it may scan lots of row maybe some useful index is missing
* row lock contention, maybe there are concurrent transactions updating the same rows. Maybe even dead locks.
Regards,
Mauritz
Subject
Views
Written By
Posted
300
January 05, 2024 09:35PM
145
January 10, 2024 06:05AM
Re: Error 4009
138
January 10, 2024 06:18AM
226
January 10, 2024 06:34AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.