Oracle Cloud Infrastructure Documentation

DBaaS ADB

Using the DBaaS ADB subject area, you can create reports about the autonomous databases and autonomous VM Cluster resources.

These reports enable you to track the different attributes and metrics for autonomous databases and autonomous VM Cluster resources across tenancies and compartments.

Business Questions

The subject area can answer following business questions about Autonomous Database Cluster and Autonomous Database details:

  • What is the total number of autonomous database count?
  • What is the total number of autonomous VM cluster count?
  • What is the total number of available autonomous database storage size?
  • What is the total number of autonomous container database count?
  • What is the total number of provisioned CPU count?
  • What is the total number of reserved CPU count?

Logical Model


Fact table Dbaas Autonomous DB Fact connected to fourteen dimension tables, Subscription, Tenancy, Compartment, Date, Region, Availability Domain, Vcn, Vcn Subnet, Dbaas Cloud Autonomous Vm Cluster, Dbaas Autonomous Container Database, Dbaas Autonomous Database, Dbaas Exadta Infrastructure, Dbaas Autonomous Database Backup, and Compute Instance - Fact.


Fact table Dbaas Autonomous vm Cluster connected to fifteen dimension tables, Subscription, Tenancy, Compartment, Date, Region, Availability Domain, Vcn, Vcn Subnet, Dbaas Cloud Autonomous Vm Cluster, Dbaas Autonomous Container Database, Dbaas Autonomous Virtual Machine, Dbaas Autonomous Vm Cluster, Dbaas Last Maintenance Run, Dbaas Next Maintenance Run, and Compute Instance - Fact.

Metric Details

The fact folders in this subject area show the following metrics:
Metric Details for Autonomous Database
Metric Description
Actual Used Data Storage Size In Tbs This metric is calculated as the sum of total amount of data used in Terabytes.
Additional Storage Size In Tbs This metric is calculated as the sum of total additional storage size used in Terabytes, derived from the actual used data storage size subtracted from the allocated storage size.
Autonomous Db Count This metric is calculated as the count of total records in Autonomous Database fact.
Backup Count This metric is calculated as the sum of total number of backups of database.
Backup Size In Tbs This metric is calculated as the sum of total size of backups of database in Terabytes.
Compute Count This metric is calculated as the sum of total number of compute amount (CPU's) available.
Cpu Core Count This metric is calculated as the sum of total number of cpu cores allocated.
Data Storage Size In Gbs This metric is calculated as the sum of total quantity of data stored in database in Gigabytes.
Data Storage Size In Tbs This metric is calculated as the sum of total quantity of data stored in database in Terabytes.
Ocpu Count This metric is calculated as the sum of total number of ocpu cores available.
Used Data Storage Size In Gbs This metric is calculated as the sum of total storage space consumed in Gigabytes.
Used Data Storage Size In Tbs This metric is calculated as the sum of total storage space consumed in Terabytes.
Metric Details for Autonomous VM Cluster
Metric Description
Autonomous Database Count This metric is calculated as the sum of total number of autonomous databases.
Autonomous Virtual Machine Count This metric is calculated as the sum of total number of autonomous virtual machines.
Autonomous Vm Cluster Count This metric is calculated as the count of total records in Autonomous VM Cluster fact.
Available Autonomous Data Storage Size In Tbs This metric is calculated as the sum of total data disk group size available for Autonomous Databases in Terabytes.
Available Container Database Count This metric is calculated as the sum of total number of Autonomous Container Databases that can be created with the currently available local storage.
Available Cpu Count This metric is calculated as the sum of total number CPU cores available.
Container Database Count This metric is calculated as the sum of total number of Autonomous Container Databases that can be created.
Cpu Count This metric is calculated as the sum of total number of CPUs available in Autonomous VM Cluster.
Data Storage Size In Tbs This metric is calculated as the sum of total data storage size allocated in Terabytes.
Memory Per Oracle Compute Unit In Gbs This metric is calculated as the sum of amount of memory (in GBs) to be enabled per OCPU or ECPU.
Memory Size In Gbs This metric is calculated as the sum of total memory allocated in Gigabytes.
Non Provisionable Autonomous Container Database Count This metric is calculated as the sum of total number of nonprovisionable Autonomous Container Databases in an Autonomous VM Cluster.
Pluggable Database Count This metric is calculated as the sum of total number of Pluggable Databases in the autonomous container databases in an Autonomous VM Cluster.
Provisionable Autonomous Container Database Count This metric is calculated as the sum of total number of provisionable Autonomous Container Databases in an Autonomous VM Cluster.
Provisioned Autonomous Container Database Count This metric is calculated as the sum of total number of provisioned Autonomous Container Databases in an Autonomous VM Cluster.
Provisioned Cpu Count This metric is calculated as the sum of total number of CPUs provisioned in Autonomous VM Cluster.
Reclaimable Cpu Count This metric is calculated as the sum of total number of CPUs that continue to be included in the count of CPUs available to the Autonomous Container Database even after one of its Autonomous Databases is stopped or scaled down.
Reserved Cpu Count This metric is calculated as the sum of total number of CPUs reserved in Autonomous VM Cluster.