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

Spotlight on Oracle 11.0 is a minor release, with no new functionality. See Resolved issues.

New Features

Spotlight on Oracle 11.0

This release includes support for the following databases and platforms:

Oracle 21c database
Windows 11
Windows Server 2022
Red Hat Enterprise Linux 8.8
Oracle Linux 8.8

Resolved Issues and Enhancements

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

Enhancements	ID
When users attempt to use the Predictive Diagnostics Settings in Spotlight On Oracle on the Oracle 21c database, an error is displayed, stating that '"" is not a valid integer value'.	SOO- 3000
On the Spotlight Console, the Next Date field under the DBMS_Jobs tab incorrectly displays a past default date.	SOO- 2998
The Buffer Cache Details table only shows details for SYS object names; information for non-SYS object names is not visible in the table.	SOO- 2940
After connecting to an RAC database, changing the Cluster Balance Threshold value under the Threshold tab in Spotlight on Oracle does not update the displayed value in the system.	SOO- 2921

Deprecated Features

We have not deprecated any feature in the current release.

Outils libre-service: Base de connaissances; Notifications et alertes; Support produits; Téléchargements de logiciels; Documentation technique; Forums utilisateurs; Didacticiels vidéo; Flux RSS

Nous contacter: Obtenir une assistance en matière de licence; Support Technique; Afficher tout

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

Spotlight on Oracle 11.0 - Release Notes

Release Notes

Spotlight® on Oracle 11.0

About this release