Discussions
Categories
- 382.6K All Categories
- 2.1K Data
- 212 Big Data Appliance
- 1.9K Data Science
- 448.4K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 541 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 499 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.8K Development
- 9 Developer Projects
- 130 Programming Languages
- 290.5K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 200 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 292 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 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
