Release Notes

Spotlight^® on Oracle 10.7.1

Release Notes

April 2019

These release notes provide information about the Spotlight^® on Oracle release.

Topics:

About this release

Spotlight is a powerful diagnostic and resolution tool for Oracle databases. Its unique user interface provides you with an intuitive, visual representation of the activity on your database. Graphical flows illustrate the rate at which data is moving between database components. Icons display the value of key statistics and metrics.

Spotlight on Oracle

Spotlight on Oracle is used to diagnose the performance of Oracle instances running on individual host machines. It also includes the following products:

• Predictive Diagnostics. Use this to predict the future performance for individual SQL statements, bottlenecks, and database resources on the Oracle database.
• Spotlight on Unix and Spotlight on Windows. Launch the appropriate O/S Spotlight automatically when Spotlight connects to an Oracle database.
• Spotlight on MySQL. Diagnose the performance of MySQL instances.
• When delivered as part of the Toad^® DBA Suite for Oracle, Spotlight incorporates SQL Optimizer for Oracle. SQL Optimizer offers a fully automated approach to maximizing SQL performance. It eliminates the manual, time-intensive process of ensuring that SQL code is performing as fast as possible.

Spotlight on Oracle RAC

Spotlight on Oracle RAC requires additional licensing. It enables the diagnosis of Oracle databases on multiple host machines under the Real Application Clusters (RAC) architecture and additionally may include monitoring of Exadata systems depending on the license purchased.

New Features

Spotlight on Oracle 10.7.1

Spotlight on Oracle 10.7.1 is a maintenance release with no new functionality.

Spotlight on Oracle 10.7

Spotlight on Oracle 10.7 now supports monitoring Oracle 18c databases and connecting to the Oracle 18c client.

Spotlight on Oracle 10.6

Spotlight on Oracle 10.6 is a maintenance release with no new functionality.

Spotlight on Oracle 10.5

Spotlight on Oracle 10.5 is a maintenance release with no new functionality.

Spotlight on Oracle 10.4

Spotlight on Oracle 10.4 is a maintenance release with no new functionality.

Spotlight on Oracle 10.3.3

Spotlight on Oracle 10.3.3 is a maintenance release with no new functionality.

Spotlight on Oracle 10.3.2

Spotlight on Oracle 10.3.2 is a maintenance release with no new functionality.

Spotlight on Oracle 10.3.1

Windows 10: Windows 10 is a supported platform for the installation of Spotlight on Oracle and the Spotlight Diagnostic Server, and for monitoring.

Spotlight on Oracle 10.3

In-Memory Diagnostics: Spotlight now provides diagnostic information for In-Memory databases in Oracle and Oracle RAC. What is the cost to the database of enabling In-Memory? Has the right amount of memory been allocated to the In-Memory column store? To what extent is I/O being consumed by In-Memory activities? Drilldown further by segments, SQL, statistics and sessions.

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release.

Deprecated Features

The option to disable User Experience Feedback has been removed. Acceptance of providing User Experience Feedback and the Feedback given is covered by the Software Transaction Agreement.