Apologies in advance I am sure I have missed a best practice / recommendation / documentation somewhere.
I use customer ORDS + APEX + ADB - created as workload type = ADW (now known as Lakehouse) and connect via LOW service.
If I switch to MEDIUM, I see parallel DML ( which I cannot disable at session level )
I suspect I should be using ADB workload type = ATP and using service = TP to
a) have APEX work optimally
b) avoid unwanted parallel dml
Questions
- Can I convert from ADW to ATP - suspect answer is no since I see no option
- Before I delete and recreate ADB, is my logic above correct - any references I should review?
Below for my own reference
https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/predefined-database-services-names.html#GUID-6CEFC4B7-6EF8-4237-A004-C88F570A480B
https://docs.oracle.com/en/database/oracle/apex/24.2/htmdb/about-limiting-resources.html
https://forums.oracle.com/ords/apexds/post/disable-parallel-slave-3740