Welcome to Spotlight
Spotlight® on Oracle 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. Observe actual database activity in real time.
The power of Spotlight on Oracle lies in its ability to provide visual and audible warnings if the performance metrics exceed acceptable thresholds. The components and data flows change color to show you the source of the problem. Spotlight on Oracle provides detailed information about a specific component allowing you to pinpoint the source of problems.
Spotlight on Oracle incorporates:
Notes:
- 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.
- 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.
Install Spotlight
Requirements
| User Privileges |
Ensure the Windows user installing Spotlight has Windows Administrator privileges. |
|
Folder Permissions |
During installation, Spotlight requires write access to the following:
- The Spotlight installation folder (by default, Program Files\Quest Software\Spotlight)
- ProgramData\Quest Software\Spotlight
- Users\<current user>\AppData\Roaming\Quest Software\Spotlight
Notes: On a 64-bit operating system the Program Files directory is Program Files (x86). |
|
Permissions to Windows registry keys and sub-keys |
During installation, Spotlight requires write access to the following:
Note: Wow6432Node is applicable only for 32-bit Spotlight run on 64-bit operating systems. |
Steps To Install
To install Spotlight from CD:
-
Close all open applications on your PC.
-
Insert the Spotlight Installer CD into your CD-ROM drive.
If the installation program does not start select Windows Start | Run
- For Spotlight delivered as part of the Toad DBA Suite for Oracle, enter the command d:\TOAD DBA Suite for Oracle vvv.exe (where d: is the CD-ROM identifier and vvv is the Spotlight version).
- For Spotlight delivered as a standalone installer, enter the command d:\SpotlightonOracle_vvv.exe (where d: is the CD-ROM identifier and vvv is the Spotlight version).
- Follow the instructions on the screen to complete the installation.
To install Spotlight from the downloaded installer:
- Close all open applications on your PC.
- Execute the downloaded installer.
- Follow the instructions on the screen to complete the installation.
Note: To cancel installation at any time, press Esc or click Cancel.
Multiple Concurrent Installations
There has been a major shift in the architecture from Spotlight on Oracle 9.5. You can install major and minor versions of Spotlight on Oracle side by side (or upgrade). Patch and progressive builds will upgrade.
Note: If Spotlight is delivered as part of the Toad DBA Suite and you require multiple Spotlight installations on your computer then contact Quest Software for more information.
MSI Installers for Spotlight on Oracle
MSI installers are available for Spotlight on Oracle. These installers can be run silently, and produce an installation that can be captured and re-used via automatic deployment techniques.
Contact Quest Software for more information.
