Note:

Generate Attributed Cost and Usage Analysis Report for Pluggable Databases on Oracle Exadata Database Service

Introduction

We are pleased to announce the general availability (GA) of the attributed usage and cost feature for Pluggable Databases (PDBs) running on Oracle Exadata Database Service on Dedicated Infrastructure and Oracle Exadata Database Service on Cloud@Customer. This feature is intended to provide the ability to view the attributed usage and costs for all PDBs in a Virtual Machine (VM) cluster.

Note: This feature allows you to query attributed PDB usage based on user-defined tags and identify costs per application and charge back these attributed costs to various line of business (Departments, Business units, and so on) for better reporting and accounting.

Objectives

Task 1: Generate Attributed Cost and Usage Analysis Report

  1. Log in to the OCI Console, go to Billing & Cost Management, Cost Management and click Cost Analysis.

    Image showing OCI Console Navigation

  2. In Reports, select one of the predefined reports, or use the default Costs by Service report.

    Image showing costs by service type of report selection

    Enter the following information.

    • Show: Select Attributed cost.

      Image showing selecting Attributed cost

    • Filters: Click Add Filter and select Tag.

      Image showing add filters

      Image showing filter selection

    • In Tag, enter the following information.

      • Tag Namespace: Select orcl-cloud.
      • Tag Key: Select parent_resource_id_1.
      • Select Match any of the following and enter OCID of the VM cluster.

      Image showing filter details

    • In Grouping dimensions, select Resource OCID.

      Note: The VM cluster OCID is the parent of the Container Databases (CDBs) it contains, and the CDB OCID is the parent OCID of the PDBs it contains.

      Image showing selecting resource ocid for grouping dimensions

  3. Click Apply to apply the changes.

    Image showing apply

    The generated report will show the attributed costs for all PDBs in the VM Cluster.

    Image showing attributed costs for PDBs

  4. Click Save as new report to save a report.

    Image showing to save as new report

  5. In Save as new report, enter the report Name and click Save.

    Image showing to save the report

    A notification is displayed that your report has been saved, and the report is also selected in the Reports menu.

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.