I have recently installed for first time Oracle XE 18c with APEX 18.2.
I have installed it in a VPS with 2GB RAM and 20GB SSD.
I have manually activated a swap file of 2GB.
I have followed the installation procedure but I have done no changes at point 2.2:
https://docs.oracle.com/database/apex-18.2/HTMIG/Oracle-AE-installation-requirements.htm#HTMIG376
Documentation states:
2.2 Checking the MEMORY_TARGET of the Target Database
...
"Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB.
Databases typically use automatic memory management, where the memory can be controlled by the server parameter MEMORY_TARGET. If your database does not use automatic memory management, consult the Oracle Database Administrator's Guide to find out how to configure manual memory parameters (for example, SGA_TARGET, PGA_AGGREGATE_TARGET, SHARED_POOL_SIZE) instead, for a similar result."
...
"If the value is 0, your database is using manual memory management. Consult the Oracle Database Administrator’s Guide to learn how to configure an equivalent memory size using manual memory management, instead of continuing with the steps that follow. "
I do not know what shall be changed in the case of Oracle 18c XE where it seems that manual memory parameters are used. So I did not change anything.
APEX works fine but it takes a really long time to do operations, specially in the administration/developing pages.
In ORDS log I get warning messages about DB taking long to response:
Dec 07, 2018 10:03:28 PM
WARNING:
** Request had db ELAPSED time of :5214ms **
Dec 07, 2018 10:03:54 PM
WARNING:
** Request had db ELAPSED time of :23534ms **
Dec 07, 2018 10:05:54 PM oracle.dbtools.rt.resource.templates.cache.MetadataCachesProvider activate
INFO: Enabling metadata cache
Dec 07, 2018 10:06:19 PM
WARNING:
** Request had db ELAPSED time of :121840ms **
Dec 07, 2018 10:07:25 PM
WARNING:
** Request had db ELAPSED time of :53622ms **
Dec 07, 2018 10:08:02 PM
WARNING:
** Request had db ELAPSED time of :91269ms **
Dec 07, 2018 10:08:02 PM
WARNING:
** Request had db ELAPSED time of :91281ms **
Opening for example a new created page took almost 2 minutes.
Clearly there is something wrong in my setup. I have used in the past 11g XE with APEX5.1 and it was really fast in the same VPSs.
Any tip on what might be wrong or what would be the next steps to further troubleshoot would be appreciated. Thanks.