I want to configure APEX such that cpu time is limited, ideally different limits for different users.
I have a 21c Autonomous Transaction Database on shared infrastructure (Always Free). APEX is configured. I have standard database ADMIN user, and standard APEX demo workspace/user.
I can connect from desktop client e.g. sql developer via database service (where SWITCH_ELAPSED_TIME is set) as DEMO and all works fine, so Resource Manager working ok.
I want to do same for APEX users/service/workspace (sorry - new to APEX) but unclear whether this is possible.
Documentation is unclear - some implies possible via Workspace Isoation but I am wondering if this is possible only on-premise, since other docs imply it is not possible.
This link would imply that I could map the Workspace to a Resource Consumer Group (Workspace Isolation technique)
https://docs.oracle.com/en/database/oracle/application-express/20.1/aeadm/isolating-workspace-to-prevent-browser-attacks.html#GUID-39A99209-B587-44DE-8C5D-19B9906C7D94 : "At the beginning of every request, the Application Express engine switches the current consumer group of the current database session to the workspace's consumer group."
However, this link implies there is a (unspecified) restriction
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/apex-restrictions.html#GUID-E13D5044-B9DD-4168-8A12-C99532940DA9 : "Security (HTTP Protocol, Real Application Security, Session Time Out, Workspace Isolation, Region and Web Service Excluded Domains, Authentication Control, Password Policy)."
I am struggling with cloud interface, and consistently hit 500 errors (SR logged but not hopeful of response).
When I bypass this error (not sure how), I can see existing Workspaces but cannot find Workspace Isolation.
Any advice appreciated.