Perform Fine-grained Data Analysis
Oracle SQL Warehouse allows you to perform fine-grained data analysis to optimize SQL performance.
To perform fine-grained data analysis:
- Select a single database from the Database drop-down 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. - 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. - 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.