Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

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

Configuration Page

Note: Available for Oracle 10.2 and later.

The Configuration page shows the services defined for the Oracle RAC cluster, and their deployment.

To open the Configuration page

Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
Click Services | Configuration.

Column	Description
Instance	The database instance where the service is deployed.
Service	The name of the service.
Blocked?	Is the service on this instance blocked from accepting new connections?
Connection Load Balance Goal	The load-balancing method used to determine how to distribute new connections to instances in the cluster. LONG — For applications that have long-lived connections. SHORT — For applications that have short-lived connections.
Workload Goal	The load-balancing method used to determine how to direct work requests to instances in the cluster. NONE. SERVICE_TIME — Directs work requests to instances according to response times. THROUGHPUT — Directs work requests to instances according to the percentage of total response time that the CPU consumes for the service.
Creation Date	The creation date for the service.
HA Events Enabled?	Are AQ (Advanced Queuing) notifications sent for HA (High Availability) events (YES or NO)? Tip: For more information on AQ notifications and HA events, see the Oracle Database Help Center.
Network	The name of the network.
DTP Flag	This flag (Y or N) indicates whether the service is for DTP (Distributed Transaction Processing) transactions. Tip: For more information on DTP, see the Oracle Database Help Center

Related Topics

Spotlight on Oracle RAC Drilldowns

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating