Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Isolating custom schema resource usage through PDB or separate consumer group

Accepted answer
23
Views
2
Comments
DMD
DMD Rank 2 - Community Beginner
edited Nov 1, 2024 6:57PM in Oracle Fusion Data Intelligence

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)

Best Answer

  • RajeshPolavarapu-Oracle
    RajeshPolavarapu-Oracle Rank 6 - Analytics Lead
    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.

Answers

  • DMD
    DMD Rank 2 - Community Beginner

    Thanks Rajesh, any thoughts on the creation of an additional consumer group and assigning all sessions from a custom schema to that consumer group?