Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX framework is too slow responding to pages requests

Eslam_ElbyalyAug 19 2020 — edited Sep 18 2020

Hi,

I am using APEX 20.1, ords-20.2.0.178.1804, DB 18c XE , windows 7 64bits, Google chrome Version 84.0.4147.125 (Official Build) (64-bit) and opera Version:70.0.3728.106.

The problem occurred too when I used 12c release 1 enterprise edition with apex 18.2 and ords 18.4.

I have a performance problem with the app builder and my custom created app. The following three videos shows the time it takes to open or submit a page in the app builder and in my custom app. There is a video with a test app page which has one form with only 5 page items which does not take long time as the app builder and my app takes but I think it's considered long as it only have 1 region.

I do not think I am violating any best practices that could affect performance. What could be the cause for that?

P.S. I cleared the standby memory and had about 500 MB free ram when recording those videos.

Custom app performance:

https://www.youtube.com/watch?v=PQ8t1Rj8heo

Test app:

https://www.youtube.com/watch?v=zfUm0CUW-cg

App Builder:

https://www.youtube.com/watch?v=7fz31jimCuA

Edited:

I installed the database using DBCA, so, Automatic Memory Management is used.

Database, APEX and ORDS all are installed on the D partition not on C. Could that be a cause of the problem?

Comments
Post Details
Added on Aug 19 2020
37 comments
6,368 views