Monitor Elastic Pool Usage and Cost Savings

The OCI Cost & Usage Analytics application illustrates elastic pool usage and billing in a graphical representation. It helps in analyzing cost, usage, and budgets for your compute resources in the Oracle Cloud Infrastructure console.

Not only can you obtain the billed ECPU count but also check the peak ECPU utilization of the pool leader and of each member. These breakdown details help identify the pool member or members that contribute to high usage of your compute resources. The application displays ECPU count in the multiples of 1x, 2x, or 4x the pool size. When a member is no longer in an elastic pool, the application still displays details about that member until it belonged to the pool.

You can use OCI usage reports and OCI_USAGE_DATA view to obtain elastic pool usage details in Oracle Cloud Infrastructure (OCI) until January 31, 2025.

See Cost and Usage Reports and OCI_USAGE_DATA_EXT View for more information.

The following table shows the product/resource column values in an OCI usage report. The OCI usage report provides details on elastic pool usage for the pool leader and for pool members a given billing hour (similar information is available in OCI_USAGE_DATA view):

SELECT billed_quantity FROM OCI_USAGE_DATA
   WHERE resource_name='PIC_ADBS_DB_ECPU_PEAK' and
                resource_id=OCID_of_the_pool_member and
                interval_usage_start=start_time and
                interval_usage_end=end_time

SELECT billed_quantity FROM OCI_USAGE_DATA
   WHERE resource_name='PIC_ADBS_DB_ECPU_PEAK' and
                resource_id=OCID_of_the_pool_leader and
                interval_usage_start=start_time and
                interval_usage_end=end_time

SELECT billed_quantity FROM OCI_USAGE_DATA
   WHERE resource_name='PIC_ADBS_ELASTIC_POOL_DB_ECPU' and
                resource_id=OCID_of_the_pool_leader and
                interval_usage_start=start_time and
                interval_usage_end=end_time

Notes for elastic pool billing information in the OCI usage report and the OCI_USAGE_DATA view:

• Elastic pool aggregate peak ECPU usage is shown for terminated databases.

• Elastic pool aggregate peak ECPU usage is shown for non-pool databases that were part of an elastic pool during a billing hour when the database was a member of an elastic pool.

See Billing Information: Autonomous AI Transaction Processing ECPU Compute Model and Track Oracle Cloud Infrastructure Resources, Cost and Usage Reports with Autonomous AI Database Views for more information.

You can use OCI cost reports and OCI_COST_DATA view to obtain elastic pool cost details in Oracle Cloud Infrastructure (OCI) after January 31, 2025.

See Cost and Usage Reports and OCI_COST_DATA_EXT View for more information.

The following table shows the product/resource column values in an OCI cost report. The OCI cost report provides details on elastic pool usage for the pool leader and for pool members for a given billing hour and similar information is available in OCI_COST_DATA view.

SELECT billed_quantity FROM OCI_COST_DATA
   WHERE product_description='Autonomous Database - Elastic Pool Individual DB  Peak ECPU' and
                resource_id=OCID_of_the_pool_member and
                interval_usage_start=start_time and
                interval_usage_end=end_time

SELECT billed_quantity FROM OCI_COST_DATA
    WHERE 
        product_description='Autonomous Database - Elastic  Pool Individual DB Peak ECPU' and
        resource_id=OCID_of_the_pool_leader and
        interval_usage_start=start_time and
        interval_usage_end=end_time

SELECT billed_quantity FROM OCI_COST_DATA
   WHERE product_description='Autonomous Database - Elastic  Pool ECPU' and
            resource_id=OCID_of_the_pool_leader and
            interval_usage_start=start_time and
            interval_usage_end=end_time

Notes for elastic pool billing information in the OCI cost report and the OCI_COST_DATA view:

• Elastic pool aggregate peak ECPU usage is shown for terminated databases.

• Elastic pool aggregate peak ECPU usage is shown for non-pool databases that were part of an elastic pool during a billing hour when the database was a member of an elastic pool.

See Billing Information: Autonomous AI Transaction Processing ECPU Compute Model and Track Oracle Cloud Infrastructure Resources, Cost and Usage Reports with Autonomous AI Database Views for more information.

You can view the elastic pool cost savings achieved for your database from its Details page on the Oracle Cloud Infrastructure (OCI) console.

To view the elastic pool cost savings:

1. On the Oracle Cloud Infrastructure console, click the hamburger menu in the top corner to display the navigation menu.
2. Click Oracle AI Database in the navigation menu and select Autonomous AI Database.

   The Autonomous AI Databases page opens, showing the list of databases in your current Compartment.

3. On the Autonomous AI Databases page, select your Autonomous Database from the links under the Display name column.
4. On the Autonomous AI Database Information tab, under Resource Allocation, click the Actions icon next to Elastic pool, and select View elastic pool cost savings.

   The Elastic pool cost savings dialog opens.

   Note
   
   

   If the elastic pool is created in the current calendar month, the View Elastic Pool Cost Savings button remains disabled until the next calendar month.

5. The Elastic pool cost savings dialog displays the following fields over the last three calendar months:
   • Usage with Elastic Pool:This field displays the cost of the elastic pool for the specific calendar month, measured in ECPU hours.
   • Estimated usage without Elastic Pool: This field displays the projected cost you would spend if you did not have an elastic pool.
   • Cost Savings with Elastic Pool: This field displays the cost savings in %. It is calculated based on the difference between Estimated usage without Elastic Pool and Usage with Elastic Pool.

6. Optionally, you can toggle to enable the Display projected cost savings with auto scaling field. This toggle is disabled by default.

   When you enable the Display projected cost savings with auto scaling toggle, the Estimated usage without Elastic Pool field displays the projected cost you would spend if all your databases in the pool were out of the pool and used compute auto-scaling.

This clear presentation of cost savings provides transparent insight into the savings achieved through elastic pooling.