Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

User Experience Feedback

You can influence the design of future versions of Spotlight and help us improve its quality, reliability and performance. To participate or change your mind select Help | User Experience Feedback.

Refer also to the Privacy Statement.


Authorize Spotlight

Spotlight is supplied with a time-limited trial key so you may test the product. When the trial key expires Spotlight reverts to a preview mode, which limits access to the Spotlight home page and one connection at a time. If you select to open a drilldown in preview mode the following message is displayed:

The current license does not allow access to this functionality.

When you enter a valid license key and authorization message in the License Viewer, you are licensed to use Spotlight on Oracle.

To enter a valid license key

While Spotlight is running

  1. Click Help | About Spotlight.
  2. Click license information.
  3. Click Change this license.
  4. Enter the Authorization key.


  • The Windows user that updates the authorization key must have administrator access to the Windows registry and write access to the Console\Licenses folder in the Spotlight installation folder.
  • Make sure you enter the authorization key exactly. The site message is case sensitive. If you enter the authorization key incorrectly, the following message is displayed: Invalid authorization key
  • If Spotlight is in preview mode and the trial period has not expired, check your computer system date is set correctly.


Spotlight on Oracle

Use Spotlight on Oracle to monitor your Oracle databases, detect and resolve problems.



Connect to an Oracle Database

Create / Modify / Delete connections to Spotlight on Oracle.

Setup Spotlight Users and complete the Oracle User Wizard.

Spotlight on Oracle Home Page The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.
Spotlight on Oracle Alarms

Spotlight alerts you to problems with your system by issuing an alarm. You can configure Spotlight in the level of severity that constitutes an alarm, to disable an alarm, and the actions Spotlight takes on raising the alarm.

Spotlight on Oracle Drilldowns When you have isolated a problem, you can display a drilldown page, whose charts and tables provide a detailed breakdown of the underlying statistics.
Tune Your Oracle Database A summary of steps you can take to tune Oracle using Spotlight on Oracle.
Spotlight on Oracle Tools: Explain Plan, SQL Optimizer, Space Manager Supportive tools and help.


Connect to an Oracle Database

  1. From the Spotlight Browser select All connections | Spotlight on Oracle
  2. Select the database.


  • Click Set timed statistics now if you are prompted to do so. You see this prompt when for the Spotlight user the timed_statistics parameter is set to false in the init.ora file. Spotlight requires this parameter be true for the Spotlight user to accurately monitor the database. Clicking Set timed statistics now corrects the problem only if the Spotlight user has Alter System privileges. Ensure the Spotlight user has sufficient privileges. Oracle User Wizard
  • If Spotlight takes too long to open the Oracle connection then Fast Initialize could be on. Oracle Initialization

Add an Oracle database to the list of connections


  • Create a Spotlight user with sufficient privileges to diagnose the Oracle database. Oracle User Wizard
  • Ensure the UNIX or Windows server on which the Oracle database is installed is accessible to Spotlight.


  1. Click File | Connect to open the Spotlight Connection Manager

  2. Select Spotlight on Oracle on the Connections menu.

  3. Double-click Add new connection.

  4. Fill in the connection Properties | Details page. Oracle Connection Details


Related Topics

Oracle User Wizard

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating