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

Spotlight on Windows Drilldowns

Once a problem is isolated you can display a drilldown page with charts and tables that provide a detailed breakdown of the underlying statistics.

Drilldown Click to open Keyboard Shortcut Drilldown Pages Description
Processes CTRL+P

Processes Page | Services Page | System Drivers Page

The Processes drilldown lists all processes and services currently running on the Windows system. You can view detailed information about each process.

CPUs CTRL+C CPUs Page | Processing Page | Multiprocessor Page

The CPU tab displays details of recent processor activity as measured by Windows.

Memory CTRL+M Summary Page | Paging Activity Page | Cache Page

The Memory drilldown displays detailed information about recent physical and virtual memory usage.

Disks CTRL+D Logical Disk Activity Page | Physical Disk Activity Page | Logical Disk Space Usage Page | Disk Summary Page | File Sizes Page

The Disks drilldown displays detailed information about the logical and physical disks on the Windows system.

Network CTRL+N Network Page | TCPIP Page | NBT Page | SPX Page | Sessions Page | Shares Page | Open Ports Page | cLAN Gigabit Page

The Network drilldown displays detailed information about the network activity to and from the Windows system.

Activity Summary CTRL+A Activity Summary Page

The Activity Summary drilldown displays summaries of recent Windows activity including, paging and packet rates, CPU usage across all processors, the number of threads waiting to be run, and the number of I/O requests that were queued for each logical disk.

Event Log CTRL+E Event Log Page

The Event Log drilldown shows recent event log items that have occurred on the Windows system.

Single Application CTRL+S Summary Page | CPUs Page | Memory Page | Disks Page

The Single Application drilldown displays detailed information about specified individual processes (or a group of processes) on a Windows system.

Choose the processes you want Spotlight to analyze from View | Options | Data collection | Windows applications metrics.

Alarm Log CTRL+L

Alarm log | Alarms by Time | Spotlight Today

The Alarm Log drilldown displays information on the alarms associated with the Windows system, including the name of the component that issued the alarm, the date and time the alarm was logged, and the severity of the alarm.

Note: The Alarm Log drilldown is common to all Spotlight applications. The alarms are specific to the current Spotlight connection. Spotlight on Windows Alarms


Related Topics

Spotlight on MySQL

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



Connect to a MySQL Database Create / Modify / Delete connections to MySQL systems.
Spotlight on MySQL 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 MySQL 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 MySQL 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.


Connect to a MySQL Database

  1. From the Spotlight Browser select All connectionsSpotlight on MySQL
  2. Select the database to connect to.


Add a MySQL database to the list of connections

Note: Ensure the Unix or Windows server on which the MySQL database is installed is accessible to Spotlight.

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

  2. Select Spotlight on MySQL on the Connections menu.

  3. Double-click Add new connection.

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


Related Topics

Spotlight Browser

MySQL Connection Details

Field Description
Connection name

This is the display name for the connection in Spotlight.

Tip: Fill in the Host field first.

MySQL connection details

Field Description
Host Enter the name of the host machine for the MySQL database.

Enter the user name to login to the MySQL database.


Enter the password to login to the MySQL database.

Port Enter the port used for the Spotlight on MySQL connection. The default value is 3306.
Database Select the name of the database that you wish to connect to.

OS Connection Details

Field Description
Monitor OS

Select to monitor the operating system on the database server.

Tip: Clear this option if the database is running on an operating system that is NOT supported by Spotlight on MySQL. If you leave this option checked and Spotlight on MySQL is unable to collect statistics from the server operating system, you may experience errors.


Enter the address of the host machine for the MySQL database.

OS Type

Select the type of operating system.

  • Windows
  • Unix(REXEC)
  • Unix(SSH)

If you select one of the Unix systems, make sure the SSH or REXEC daemon is running on the database server and is configured to receive remote connections.

SSH Port

Enter the port number for SSH (secure shell) connection to the database server. The default value is 22.

Note: Applicable when OS Type is Unix(SSH).


Type the user name to login to the database server.

Note: When OS Type is Windows:

  • Not required if your login details have been assigned remote access to the registry of the database server.
  • Ensure the user has access to the registry of the server.


Type the user password to login to the database server (if required).

Click Save password details (for this connection) to save all the entered password details.


Related Topics

Spotlight Connection Manager

All connections

Spotlight Today

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating