Compute

Using the Compute subject area, you can create reports about the Compute instance resources.

With these reports, you can track the different attributes and metrics for Compute instance resources across tenancies and compartments.

You can also see details on additional network components, such as NSGs, Route Tables, and public and private IPs associated with a Compute instance. And, for more specific use cases, you can view the Compute instances along with their assigned tags.

Business Questions

The subject area can answer the following business questions:

  • What is the total number of secondary Vnics attached to Compute instances?
  • What is the total number of volumes attached to Compute instances?
  • What is the total number of Compute count?
  • What is the total number of GPU count?
  • What is the total number of OCPU count?
  • What is the total amount of memory used?
  • What NSGs are associated with my Compute instance?
  • What public and private IPs are associated with my Compute instance?
  • What Route Table is associated with my Compute instance?
  • What are the tags for my Compute instance?

Logical Model

A Compute Metrics fact table is connected to the following dimension tables:


Fact table Compute Metrics connected to seventeen dimension tables, Subscription, Tenancy, Compartment, Date, Region, Availability Domain, Vcn Subnet, Compute Volume Attachment, Compute Image, Vcn Vnic, Vcn Vlan, Compute Fault Domain, Compute Boot Volume Attachment, Block Boot Volume , Compute Vnic Attachment, Compute Instance, and Compute Instance - Fact.

A Compute Network Details fact table is connected to the following dimension tables:


Fact table Compute Network Details connected to sixteen dimension tables, Subscription, Tenancy, Compartment, Date, Region, Route Table, Availability Domain, Tags, Private IP, Block Boot Volume, Public IP, Compute Vnic Attachment, VCN, Compute Instance, Network Security Group, and Compute Network Fact Details.

Metric Details

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

Metric Details for Compute
MetricDescription
Attached Secondary Vnic CountThis metric is calculated as the sum of total number secondary VNICs attached
Attached Volumes CountThis metric is calculated as the sum of total number of boot volumes attached
Compute CountThis metric is calculated as the count of total records in Compute fact
Gpu CountThis metric is calculated as the sum of total GPU usage over the hour
Memory Usage Size In MbThis metric is calculated as the sum of total memory usage over the hour in megabytes
Ocpu UsageThis metric is calculated as the sum of total OCPU usage over the hour