Oracle SQL Warehouse

The Oracle SQL Warehouse application makes it easy for you to manage SQL at scale.

Note

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

Oracle SQL Warehouse is not applicable for MySQL Heatwave Datbase Systems

Using the Oracle SQL Warehouse application of Ops Insights, you can analyze the SQL performance problems for enterprise-wide applications across a fleet of databases. In addition, Oracle SQL Warehouse provides trends and key insights to SQL performance issues thereby helping you to be proactive in avoiding future problems.

With Oracle SQL Warehouse, you can:

  • Collect SQL, execution plan and session data into a long term Oracle SQL Warehouse and store data for 25 months
  • Compare SQL execution plan between production, test and development database
  • Compare SQL performance trends across databases and drill down to execution plans for analysis
  • Identify SQL statements that were good but now turned bad even if the execution plan has not changed
  • Auto-detect anomalies by comparing current SQL response time vs. automatic baselines