Oracle Cloud Infrastructure Documentation

Viewing Usage Metrics for Oracle Exadata Database Service

View Oracle Exadata usage metrics by hardware type in Control Center.

The following information is available for the Oracle Exadata service.

  • Region-level usage metrics by consumption type and hardware type
  • In-depth usage detail for supported database compute servers.

The following kinds of hardware are supported for Oracle Exadata.

  • Quarter Rack: This includes X7 and X8 type of hardware. The data is displayed in Quarter Rack (Qtr. Rack).
  • Elastic: This includes X8M and X9M type of hardware. The data is displayed in nodes.

For more information about the Oracle Exadata service, see Oracle Exadata Database Service on Dedicated Infrastructure Overview.

  • Find a granular view of Exadata usage details with the following categories by hardware type. The labels of hardware types depend on the UI version.

    • Node Breakdown: The breakdown of infrastructure utilization data at the Compute (DB) and Storage (HC) node level.
    • Quarter Rack 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.
    • Cloud Exadata Infrastructure (CEI) Breakdown: 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).
    Open the navigation menu  and select Governance & Administration. Under Control Center, select Exadata.

    The Exadata page for Control Center opens. 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. To limit hardware types in a list, see Filtering List Results.

    Following are tasks you can do with Exadata metrics in Control Center.

    Exporting Exadata Breakdown Information

    You can export Exadata breakdown information from the Console to Excel or CSV.

    Tip

    Consider filtering Exadata details to refine the data and charts before exporting. For instructions, see Filtering Hardware Type Information.
    1. On the upper right of the Exadata page, select Export and then select the format that you want.
    2. In the Export Exadata dialog box, select the information that you want to export.
    3. Select Confirm.

    Opening the Hardware Type Details Page

    Find in-depth usage details for a supported hardware type (such as X9M). The details page for a hardware type includes filters, current snapshot, and historical charts.

    Note

    Only the hardware available in your region are displayed.
    On the Exadata page in Control Center, select the hardware type (under Hardware generation). If you need help finding this page, see Using the Console.

    Filtering Hardware Type Information

    Filter information for the current hardware type to refine its data and charts.
    1. On the hardware type details page, under Filters and Actions, select Edit. If you need help finding this page, see Opening the Hardware Type Details Page.
    2. In the Edit usage filter panel, enter the following information.
      • Compartment: Select or remove options to filter by compartment.
      • Filter by consumption type: Select or remove options to filter existing data. All filter options are enabled by default.
    3. Select Update.

    Viewing the Current Snapshot

    Find the current usage and the available capacity in Quarter Rack or nodes based on the selected hardware from the Current Snapshot graph. Data depends on filter options.

    The usage is calculated based on an hourly usage average for a specific day. Usage includes the following details.

    • Overhead: Represents the capacity required to manage database compute servers.
    • OCI: Represents the database (DB) compute servers and high capacity (HC) consumption on X8M and X9M systems.
    • Customer: Represents the actual usage and no additional usages.
    • Available: Represents the total capacity that's available to you in a specific environment.
    On the hardware type details page, find the Current Snapshot graph. If you need help finding this page, see Opening the Hardware Type Details Page.

    Viewing Usage by Tenancy

    Find Compute usage by the customer tenancy.
    On the hardware type details page, expand Compute usage by tenancy. If you need help finding this page, see Opening the Hardware Type Details Page. Data depends on filter options.

    Viewing Historical Charts and Organic Forecasting

    Historical data represents the consumption of all overhead usage, OCI usage, customer usage, and available capacity in the last 30 days by default. Enable organic forecasting and find the usage projection based on heuristic.
    1. On the hardware type details page, scroll down to the Historical charts section. If you need help finding this page, see Opening the Hardware Type Details Page.
    2. To change the time period, select Select time frame (under Historical charts).
    3. To enable organic forecasting, do the following.
      1. Under Historical charts, select Select time frame.
      2. In the Select time frame panel, turn on Forecast toggle.
      3. Select the start and end dates that you want.
      4. Select Update.

      Information 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 within to the Historical chart.

    Exporting the Hardware Type Details

    You can export the hardware type details from the Console to Excel, CSV, or PPTX.

    Tip

    Consider filtering hardware type details to refine the data and charts before exporting. For instructions, see Filtering Hardware Type Information.
    1. On the upper right of the hardware type details page, select Export and then select the format that you want.
    2. In the Export Exadata dialog box, select the information that you want to export.
    3. Select Confirm.

    Filtering List Results

    Use filters to limit the items in a list, such as hardware generation items in the Node Breakdown section.

    From the Search and Filter box above the list table, select one or more filters and specify the values that you want to use to narrow the list. In general, the filters correspond to the columns shown in the list table, although some filters represent attributes that aren't shown in the table. The Compartment filter is always displayed next to Applied filters.

    Change the order of the items in the list table by using the sort icons next to the column names.

    For information about searching for resources and managing the columns in the list table, see Listing Resources.

  • 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. 

    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.