Hi.
We have performance issue after upgrade from 20.4 to 21.1 version. ORDS is only used for APEX applications.
RDBMS Version 18.5, RAC, 2 nodes. APEX version 19.2.
In version 21.1 ORDS executes on every request sql : "SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'APEX_RELEASE' AND TABLE_NAME = 'APEX_RELEASE'"
In our environment, this request takes about 2-3 seconds, so if there are several hundred active users, everything hangs...
We have created SR regarding the performance of a query to the system dictionary, but there is no solution yet.
What recommendations can be in this case?