Hi All,
we have issues with the ORDS / APEX performance and have a hard time to identify the root cause. We have ORDS 21.2 running on Tomcat, connecting to about 5 different databases having APEX 21.1.3 installed. CPU usage of Tomcat is very high and in the log we can see a huge list of warning messages such as
05-Oct-2022 09:05:35.419 WARNING [ajp-nio-8010-exec-39] oracle.dbtools.common.logging.JDKLogSink.record <...>
** Request had db ELAPSED time of :129009ms **
Does someone know how we can identify from which database / request these errors are coming?
regards