Create Dashboards

You can create custom dashboards on the Dashboards page by adding the Oracle-defined widgets or the custom widgets you’ve created.

Out-of-Box Dashboards

In addition to creating dashboards, Ops Insights also provides the following predefined dashboards:

Dashboard Description
Exadata Cell Dashboard - Hourly Hourly granularity dashboard for cell disk metrics. The disk metrics are aggregated across the flash and hard disks as indicated by the widget names.

Useful to help identify potential disk-related IO bottlenecks and cell outliers.

Exadata IORM Dashboard - Hourly Hourly granularity dashboard for Exadata IORM-related metrics.

This dashboard breaks down hard and flash IORM metrics helping to pinpoint heavy consumers of the cell IO resources at both database and pluggable database levels.

OPSI capacity dashboard Fleet-wide view of top utilized databases, hosts, and Exadata Systems enabled for Ops Insights.
OPSI configuration dashboard Fleet-wide view of configurations across the Ops Insights enabled databases, hosts, and Exadata systems.
SQL Insights - SQL analysis Insights and performance history for a specific SQL observed on a specific database.
SQL Insights - Database analysis Insights and performance history aggregated over all SQL observed on a specific database.
SQL Insights - Fleet analysis Insights and analytics over all SQL and all databases enabled in the compartment.

To create a dashboard:

  1. Open the navigation menu and click Observability & Management. Under Ops Insights, click Dashboards.
  2. On the Dashboards page, click Create Dashboard. The new dashboard page displays. In the lower half space of the page, you can add or create a widget. Also, in the upper half space of the page, you will need to add or create filters to apply on each widget. At the right are the About, Widgets, and Filters panes.
  3. Go to About pane. Specify the name of the dashboard, choose a compartment to place the dashboard in, and optionally provide a description for the dashboard.
  4. In the Widgets pane, search for the Oracle-defined or custom widgets. Click a widget to add it to the dashboard. Alternatively, you can drag and drop the widgets to the dashboard. To modify the widget label or description, go to the Edit Widgets tab in the Widgets pane.

    Additionally, to create and add a metric widget for the metrics generated in other services, click Create Metric Widget. See Create Metric Widgets.

    Ops Insights provides the following Oracle-defined widgets:

    Database / Host Top Consumers

    • Allows you to select which metric you want to show the top consumers of (Top 5)
      • For DB (CPU/Memory/Storage/IO)
      • For Host (CPU/Logical Memory)
    • Allows you to select which statistic you would like to show
      • Usage
      • Utilization
      • Usage Change Percent

    Database / Host Trend

    • Allows you to select which metric you want to trend (also contains the capacity line for all except IO)
      • For DB (CPU/Memory/Storage/IO)
      • For Host (CPU/Logical Memory)
    • Allows you to add a filter (Database or Host filter) to trend a single database or host resource

    Data Object Explorers

    • Allows you to display the results of predefined SQL queries run against Ops Insights data objects (curated views on top of the collected Ops Insights metrics). For more information, see Data Object Explorers and Data Object Reference.
  5. After you add the widget, you are automatically prompted to specify the required input filters. For Ops Insights, the dialog box Configure Compartment Input opens. To specify the a Compartment filter:
    • Link with an existing filter: If a compartment filter already exists in the dashboard, then you can use this option to select it.
    • Add a new filter: You can select from the filters that are already available in the Filters library.
    • Pre-define the value: Specify the compartment in which the Ops Insights resource is present.
    Note

    The following optional filters are provided:
    • For Database Trend charts, you can add a database filter
    • For Host Trend charts, you can add a host filter

    After you select the filters for the widgets, they are visible in the section in the Edit Widgets tab under Widgets pane.

    Click the edit icon edit icon adjacent to each input to modify the filter configuration for the widget.

    To perform various actions on a filter such as alter the size, edit, or delete, you can click the Content Settings content settings icon on the filter.

    Note

    • If you have selected the same compartment filter or entity filter for multiple widgets in a dashboard, then any change made to that filter impacts all the dependent widgets.
    • When your dashboard is using widgets from multiple OCI Observability & Management services, then the data might be available in different compartments or associated with different entities. In such cases, it is helpful to define separate filters for those widgets.

    Additionally, you can open the Filters pane and go to Add filters tab to add new filters to the dashboard by dragging dropping them to the filters space of the page. You can edit the filter attributes like label and description for the filters that you added in the dashboard by clicking the Edit filters tab.

  6. Click Save Changes to save the new dashboard. After you click Save Changes, the dashboard is in View mode. At a later time, if you want to make changes to the contents of your dashboard, click Edit edit icon to go to the Edit mode.

After you’ve created a dashboard, click the name of the dashboard in the Dashboards page to view it. You can use the following options on the Dashboard page to perform other tasks:

  • Click the Open icon on a widget to open the widget in the Log Explorer and make changes. If you want to make changes to a widget created by another user, you can click the Save As option in the Log Explorer to create a copy of the widget and make changes to meet your requirements. Note that the copy of the widget isn't automatically added to the dashboard and you'll have to edit the dashboard and add it.
  • Click Edit to modify the dashboard. You can add or remove custom widgets, metric widgets, change the title, description, dashboard compartment, or the filters associated with the widgets.

Create Widgets and Dashboards Using One of the Data Object Explorers

The data object explorers let you create SQL queries to extract metric data and create intuitive visualizations such as tables, line, bar, and area charts. In addition to constructing your own SQL queries, data object explorers also include out-of-box queries for immediate use. You can use any of the data object explorers to create metric widgets for inclusion in existing dashboards or create entirely new dashboards. For more information about creating dashboard metric widgets with one of the data object explorers, see Save, Share, and Export SQL Queries.

Setting up Cross-region Dashboards

By default, a dashboard widget responds to the top-level region selected for the OCI console. However, you may want to display two or more widgets in your dashboard that pull information from different regions. Dashboard cross-region support allows you to do this.

  1. From a dashboard Actions menu, select Edit.
  2. Click on the Widgets tab. The dashboard edit region displays a list of available widgets.
  3. Add a widget to the dashboard, or use an existing widget. When adding a widget to the dashboard, ensure that Link the compartmentId_displayName input with an existing filter option has been selected.
  4. From the dashboard widget's Action menu (vertical ellipses), select Edit. Configuration information for that widget displays.
  5. Under Configured widget inputs, click the Edit icon (pencil) to display the Configure Region dialog.
    Image shows the Configure Region input for a dashboard widget.

  6. Specify the region you want to use for the widget. You can either add a region filter to make it dynamic or select a static region from the drop-down menu.
  7. Click Save Changes.

Related Information

For information regarding the Management Dashboard policies that assign the permissions required to work with dashboards, see Details for Management Dashboard.

For Management Dashboard API documentation, see Management Dashboard API.