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.

自助服务工具: 知识库; 通知和警报; 产品支持; 下载软件; 技术说明文件; 用户论坛; 视频教程; RSS订阅源

联系我们: 获得许可帮助; 技术支持; 查看全部

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Spotlight on Oracle 11.0 - Release Notes

Release Notes

Spotlight® on Oracle 11.0

About this release