Oracle Cloud Infrastructure Documentation

DBaaS Exadata

Using the DBaaS Exadata subject area, you can create reports about the database systems and Exadata Cluster resources.

These reports enable you to track the different attributes and metrics for database systems and Exadata Cluster resources across tenancies and compartments.

Business Questions

The subject area can answer following business questions about Exadata and database system details:

  • What is the total data storage size?
  • What is the total number of CPU cores?
  • What is the total number of nodes?
  • What is the total number of databases?

Logical Model


Fact table Dbaas DB System connected to sixteen dimension tables, Subscription, Tenancy, Compartment, Date, Region, Availability Domain, Vcn, Vcn Subnet, Dbaas Pluggable Database, Dbaas Database Software Image, Dbaas Database, Dbaas DB Home, Dbaas Last Maintenance Run, Dbaas Next Maintenance Run, Dbaas DB System, and Dbaas DB System - Fact.


Fact table Dbaas Exadata Cluster connected to fourteen dimension tables, Subscription, Tenancy, Compartment, Date, Region, Availability Domain, Vcn, Vcn Subnet, Dbaas Cloud Vm Cluster, Dbaas Database Cluster, Dbaas DB Server - Exadata, Dbaas Vm Cluster, Dbaas Exadata Infrastructure, and Dbaas Exadata Cluster - Fact.

Metric Details

The fact folders in this subject are show the following metrics:

Metric Details for Dbaas DB System
Metric Description
Cpu Core Count This metric is calculated as the sum of total cpu cores enabled.
Data Storage Size In Gbs This metric is calculated as the sum of total data storage size available in gigabytes.
Database Count This metric is calculated as the sum of total databases.
Db Home Count This metric is calculated as the sum of total db homes.
Db System Count This metric is calculated as the count of total records in DB System fact.
Node Count This metric is calculated as the sum of total nodes.
Reco Storage Size In Gb This metric is calculated as the sum of total size of the RECO disk group in gigabytes.
Metric Details for Dbaas Exadata Cluster Fact
Metric Description
Cpus Enabled Count This metric is calculated as the sum of total CPU cores enabled on VM cluster.
Data Storage Size In Tbs This metrics is calculated as the sum of total data disk group size in TBs.
Database Count This metric is calculated as the sum of total databases.
Db Node Storage In Gbs This metrics is calculated as the sum of total local node storage allocated in Gigabytes.
Node Count This metric is calculated as the sum of total nodes on vm cluster.
Exadata Cluster Count This metric is calculated as the count of total records in Exadata Cluster fact.