Viewing Usage Metrics for Oracle Exadata Database Service

• Console
• CLI
• API

• 1. Open the navigation menu, click Governance & Administration, and then click Control Center.
     Your current region is displayed at the upper right of the Console. If your tenancy is subscribed to several regions, you can switch regions by selecting a different region from the Regions menu.
  2. Click Exadata on the left side of the page.
  3. In the Overview tab of the Region Details for Exadata page, find a granular view of Exadata usage details with the following three categories by the hardware type.
     Note
     
     If the Region Details page doesn't display any information, select a different compartment from the Compartment list (on the left side of the page).

     • Exadata infrastructure usage breakdown based on tenancy: The breakdown of actual consumption of Cloud Exadata Infrastructure (CEI) data at the Core (OCPU) level and where applicable to the elastic node configuration of the instance at the region level (beyond the baseline Quarter Rack configuration).
     • Node usage breakdown: The breakdown of infrastructure utilization data at the Compute (DB) and Storage (HC) node level.
     • Quarter Racks Usage breakdown: The breakdown of instance consumption at a minimum configuration level (also known as Quarter Rack). The minimum configuration to start an Exadata instance is 2 DB nodes and 3 HC nodes, and this view provides the current usage, and available usage at the instance (Quarter Rack) level.
  4. Click Export to export the data in Excel and CSV.
  5. Select the Exadata overview tab checkbox and then click Confirm.
  6. To find an in-depth usage details for each of the hardware that OCC supports, such as, X8M or X9M , select a specific tab.
     Note
     
     Only the hardware available in your region are displayed.
  7. Select or remove an option from the Filter by consumption type filter bar menu to filter existing data. All filter options are enabled by default.
  8. Find the current usage and the available capacity in Quarter Rack or nodes based on the selected hardware from Current snapshot - <latest available date>: graph. The usage is calculated based on an hourly usage average for a specific day. It includes the following details:
     Note
     
     When the filter options change in step 7, the Current snapshot data change.

     • Overhead usage (blue): Represents the capacity required to manage database compute servers.
     • OCI usage (red): Represents the database (DB) compute servers and high capacity (HC) consumption on X8M and X9M systems.
     • Customer usage (green): Represents the actual usage and no additional usages.
     • Available capacity (gray): Represents the total capacity that's available to you in a specific environment.
  9. Click the Usage breakdown to view usage categorization by tenancy for database (DB) compute servers and high capacity (HC) consumption.
     Note
     
     When the filter options change in step 7, the Usage breakdown data change.
  10. Under Organic forecast, switch on the Enable toggle to enable organic forecasting and find the usage projection based on heuristic, which includes overhead usage, OCI usage, customer usage, and available capacity. This projection can be used during the planning cycle to find the rate of consumption and decide on usage expansion. See Managing Organic Forecasting.
      When you enable organic forecast, the organic forecast chart is displayed next to the Historical chart. These two charts are separated by a line for comparison with the projected data.

      When selecting the start or end date, you can also select a range of periods such as one month (1M), two months (2M), and so on.

  11. View the historical data that represents the consumption of all overhead usage, OCI usage, customer usage, and available capacity in the last 30 days.

      You can select a range of periods or a custom period and find the equivalent data. The default time is the past 30 days. Hover over the historical chart to find the usage details in Quarter Rack or nodes compared to the total capacity on a specific date for database (DB) compute servers and high capacity (HC) consumption.

  12. To export the historical chart data and usage consumption data from the Console in Excel, CSV, or PPTX format, select Export (at the top right side of the page).
  13. From the export menu, select a format from the list of options and then click Confirm.

• Use the OCI control center metric data read command and required parameters to list usage information of Exadata Database Service on Dedicated Infrastructure hardware details.

  Command

  CopyTry It

  oci occ metric-data read [OPTIONS]

  For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

• Run the RequestSummarizedMetricData operation to view the usage details by consumption type and hardware type for a Exadata Database Service on Dedicated Infrastructure shape.