Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K 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
- 158 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
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 401 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Shared Component - List of Values - slow to load on Oracle Cloud
Answers
-
We are facing same problems using Oracle Cloud, Apex 20.2. The first time we came across this problem was on "bare metal" custom installation. While searching for the cause, we switched to Autonomous Transaction Processing database which is available for Free Tier users as well.
The problem is related not just to dynamic LOVs, but also to static Lists (not LOVs). After creating empty application, go to Shared Components -> Lists -> Desktop Navigation Bar -> any list entry (even "separator"). This opens list entry "Create / Edit" form (page 4052 of app 4000). There is no SQL to parse. Still, the form takes over 30s to open:
We did not encounter the issue in apex.oracle.com environment. We have no access to Apex 20.2 on-premise installation.
While the ATP issue is just annoying "bug?", since you have to wait a bit longer to load the page, the issue on bare metal (with custom installed Tomcat) resulted in error we need to get rid of. Sometimes it falls retively quickly on this error:
Sometimes this error:
Any help with this issue would be appreciated.
