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!

Shared Component - List of Values - slow to load on Oracle Cloud

Jon BarwellDec 10 2020

We are getting really slow performance from an APEX environment on the Oracle Cloud when defining List of Values as shared components.
When we try to open a list of values that uses a SQL statement it is taking 30-40 seconds to open the page, if it's a static list then opens right away.
Is this a known issue?

This post has been answered by AceSobe on Dec 11 2020

Jump to Answer

1043586

Answer

Solved:

My SQL Array Fetch Size value was blank. (Pref -> Database -> Advanced). I had set it to 1000 or so a while back (2+ years), but apparently more than 500 crashes now.

Posting resolution here in case this ever happens to someone else.

Marked as Answer by 1043586 · Sep 27 2020

1 - 1

Added on Dec 10 2020

#apex, #apex-discussions, #developer

21 comments

836 views

1 mention

APEX

Shared Component - List of Values - slow to load on Oracle Cloud

Comments

Post Details