Hi,
We have APEX running on an ATP database with customer managed ORDS. The workload for the database is about 50% directly serving APEX and the remainder is REST endpoints.
The instructions for setting up customer managed ORDS for APEX show using the LOW service but I was wondering if we should actually be using the TP service instead - as its a database that is being used for OLTP mainly?
I configured our development environment to use TP, but somewhere along the track (maybe the ORDS_GATEWAY_USER2) it switches back to using the LOW consumer group.
Is there some way to encourage ORDS to stick with the TP consumer group? I think the way to do this on a non autonomous database would be the dbms_resource_manager package, but that is not available on ATP!
The motivation for this is that we have some reporting endpoints that I would like to force to use the LOW consumer group - so they don't get as much resource and kill performance for our front end APEX users.
Regards,
Ben