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

To perform fine-grained data analysis:

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