Isolating custom schema resource usage through PDB or separate consumer group

Question

To limit competition of resources (CPU, storage, tempfiles, etc) between the delivered schemas (OAX$OAC) vs. any custom schemas, is there an opportunity/is it supported in the product to have a custom schema being allocated under a separate PDB and/or create a separate non-low, medium, or high connection consumer group and assign to the custom schema sessions?

PDB creation and management: CREATE PLUGGABLE DATABASE (oracle.com) and DBMS_PDB (oracle.com)

Consumer group creation: DBMS_RESOURCE_MANAGER (oracle.com)

RajeshPolavarapu-Oracle · Accepted Answer

Hi @Dylan Levine

FDI uses Autonomous Database Warehouse instance inside Oracle Cloud Infrastructure (OCI) for storing data.

ADW instance itself is a pluggable database, You cannot create another one inside that.

So, you cannot have separate non-low, medium or high service connections.

You may check similar question in a very generic way (do not specifying schema names like OAX$OAC ) in ADW communities.

https://community.oracle.com/customerconnect/categories/oci-autonomous-database

Thanks.