Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on Oracle 10.5 - Getting Started Guide

Table of Contents

Welcome to Spotlight Install Spotlight

Multiple Concurrent Installations MSI Installers for Spotlight on Oracle Uninstall Spotlight

Start Spotlight

Spotlight on Oracle now includes web based analytics Get Spotlight on your favorite mobile device User Experience Feedback Authorize Spotlight

Spotlight on Oracle

Connect to an Oracle Database

Oracle Connection Details

Oracle User Wizard

DBA Connection Credentials User Account New Oracle User Select Tablespace Predictive Diagnostics Ready To Configure Oracle User End

Configuring Oracle User for Spotlight Dialog Toad DBA Suite for Oracle Oracle Architecture Overview Spotlight on Oracle Home Page Spotlight on Oracle Alarms Spotlight on Oracle Drilldowns Install And Configure DTrace Scripts Tune Your Oracle Database Predictive Diagnostics Spotlight on Oracle Tools: Explain Plan, SQL Optimizer, Space Manager Spotlight on your favorite mobile device

Spotlight on Oracle Data Guard

Standby Connections Dialog Spotlight on Oracle Data Guard Home Page Spotlight on Oracle Data Guard Alarms

Spotlight on Oracle RAC

Connect to Spotlight on Oracle RAC

Oracle RAC Connection Details Verify Cluster Connection Details Dialog Connect to an Exadata Storage Server (Cells)

Spotlight on Oracle RAC Home Page Spotlight on Oracle RAC Alarms Spotlight on Oracle RAC Drilldowns

Spotlight on Unix

Configure the Unix System Connect to Unix Systems

Unix Connection Details

Spotlight on Unix Home Page Spotlight on Unix Alarms Spotlight on Unix Drilldowns

Spotlight on Windows

Connect to Windows Systems

Windows Connection Details

Spotlight on Windows Home Page Spotlight on Windows Alarms Spotlight on Windows Drilldowns

Spotlight on MySQL

Connect to a MySQL Database

MySQL Connection Details

Spotlight on MySQL Home Page Spotlight on MySQL Alarms Spotlight on MySQL Drilldowns

Troubleshooting: Connection Problems

Troubleshooting Spotlight on Windows

The Registry ... is not accessible. Connecting As The Logged-in User WMI Connection Problems

Spotlight on Oracle

SQL Criteria Wizard

Use the SQL Criteria wizard to select, retrieve and sort the SQL statements that are consuming the most system resources for the current connection.

To start the wizard

Open a Top SQL grid. (SQL & Application Workload | Top SQL Page, or I/O |SQL Page)
Click Set SQL criteria. Alternatively, right click the Top SQL grid and select Set SQL Criteria.

Classic or Standard Mode?

Mode	Description
SQL Criteria Wizard (Classic)	The mode used before Spotlight on Oracle 5.0.
SQL Criteria Wizard (Standard)	The standard mode used by Spotlight on Oracle 5.0 and later.

Notes:

Select Don't show this page again to bypass the first page of the wizard the next time you use it. Spotlight will assume the mode you choose this time is the mode you want next time.
To choose a different mode after you have chosen Don't show this page again, restart the wizard and click Back to view the first page of the wizard.

Related Topics

Spotlight on Oracle RAC Drilldowns

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center