The SQL Insights feature is based on SQL-level performance data collected on databases enabled for Ops Insights. This telemetry is presented in a daily manner, from collections occurring every 30 minutes and transferred into the Ops Insights warehouse where it is curated, persisted, and made available through data objects.

The main purpose of SQL Insights is to provide application database analysts and developers an important historical archive of detailed SQL performance data, as well as operationally useful insights derived from that data at the SQL statement, database and fleet levels.

To view the various SQL Insights, go to the top left navigation menu and click on Observability & Management. In the emerging menu locate the Ops Insights section, then Database Insights, and click on SQL Insights. The SQL Insights - Fleet analysis page is shown.

Ops Insights can provide insights for both Oracle databases, and MySQL databases. If you have both types of databases in your environment, you can select which type to view SQL Insights on by selecting it on the Database Type radio buttons at the lower left corner.

Figure 6-1 Database Types for Ops Insights