Perform Fine-grained Data Analysis

Oracle SQL Warehouse allows you to perform fine-grained data analysis to optimize SQL performance.

Note

Starting May 31st 2024 Ops Insights SQL Warehouse will be deprecated. For more information see MOS Note 3025469.1.

To perform fine-grained data analysis:

  1. Select a single database from the Database drop-down selector.
    Graphic shows the database selector.

    Note

    The selector allows you to type in a partial database name to narrow the number of entries that show up in the drop-down list.
  2. Select a time frame of 30 days or less.
    Note

    The selected time range must fall within the last 30 days. For example, you cannot select a one week range from the previous year.
  3. You can now drill down to view finer-grained SQL data. For example, open the navigation menu and then click Observability & Management. Under Ops Insights, click Oracle SQL Warehouse and then Top SQL by CPU. You can now view SQL analytic information with a higher level of granularity.
    Graphic shows Top SQL by CPU data at a higher level of granularity.