Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on Oracle 10.8 - 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 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

Session Locks Page

The Session Locks page shows the status of open locks, locks that are pending, and objects currently accessed by the session.

To open the Session Locks page

Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
Click I/O | Sessions Page.
Select a Session in the Top Sessions grid.
Click Session Locks.

Note: Alternatively, you can view Session Details on the Top Sessions | Session Locks Page.

Grids on the Session Locks Page

Grid

Description

Session Locks

Held and waiting locks. The columns in this grid are:

Type - The type of lock.
Request - Mode in which the lock is requested.
Holding - Mode in which the lock is held.
Blocking? - Is this lock blocking other users?
Object - Object upon which the lock is held.

Objects accessed

Objects that are currently accessed by the session. This includes stored programs as well as segments.

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