Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Performance issue after upgrade to ORDS 21.1

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?
Best Answer
-
Recommend you downgrade ORDS to 20.4...that statement isn't the best, it's been corrected for ords 21.2
Also, your DB is out of support as of end of June (18c) - consider upgrading that to 19c, and your APEX is also old...
Answers
-
Recommend you downgrade ORDS to 20.4...that statement isn't the best, it's been corrected for ords 21.2
Also, your DB is out of support as of end of June (18c) - consider upgrading that to 19c, and your APEX is also old...
-
Hi,
I have the same problem, in Oracle Atonomous DB.
-
right, it's the same ORDS with the same problem - we'll be staging a fix via an ords 21.1.3 ASAP for both Cloud and for Download
-
Hi,
Oracle Apex is some slow responding? I have installed apex 21-1 on DB 12-1-0-2-0 with ORDS 21-1-3-r1531102
can anyone advise about its performance tuning?
-
Same issue with ORDS 21.1, Oracle 19c, and Tomcat 9. Can anyone confirm this issue is resolved by updating to ORDS 21.2?
-
Yes, issue is resolved in version 21.1.3 or newer