I am looking for advice
APEX 24.2.7 against ADB-S 23.9 (free tier)
I have an APEX application where all relevant database code is executed within PL/SQL packages.
Using SQL Developer's Real Time SQL Monitor I see evidence of Parallelism (PX coordinator etc)
APEX connects via default LOW service.
https://docs.oracle.com/en/database/oracle/apex/24.2/htmdb/about-limiting-resources.html is unclear about parallelism.
How can I disable parallelism and be confident it will never kick-in ?
Appreciate this is not 100% APEX question - but ADB-S has limited options to configure resource manager/services etc
I have tried a number of variations of DML hints & dynamic alter session
ADB was created years ago as Workload type = Data Warehouse (ADW) - should I recreate as OLTP (ATP) ?