It takes a few minutes to view locks on the Oracle 10g database. I have changed the optimizer hints for oracle 10g from RULE to CHOOSE or FIRST ROW but this does not seem to make a difference. These few minutes seem very long when resolving locks on the database and the users are waiting.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center