Welcome to Spotlight
Install Spotlight
Start Spotlight
Spotlight on Oracle
Connect to an Oracle Database
Oracle User Wizard
Spotlight on Oracle Data Guard
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
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
Spotlight on Unix
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
Configure the Unix System
Connect to Unix Systems
Spotlight on Unix Home Page
Spotlight on Unix Alarms
Spotlight on Unix Drilldowns
Spotlight on Windows
Connect to Windows Systems
Spotlight on Windows Home Page
Spotlight on Windows Alarms
Spotlight on Windows Drilldowns
Troubleshooting: Connection Problems
Process Details Page
The Process Details page contains a detailed list of properties for the process selected on the Processes page.
To open the Process Details page
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Processes | Processes Page.
- Select a process to view its details
For the selected process
The Memory Usage chart displays data series for the virtual memory and physical memory used by the selected process. From the Memory Usage chart it is possible to detect memory leaks of the process over the display period.
The CPU Usage chart displays CPU usage for the selected process.
The information grid is as follows.
| Item | Description | |||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Process | The name of the process. | |||||||||||||||||||||||||||||||||||||||
| Process ID | The process identifier for the specified process. | |||||||||||||||||||||||||||||||||||||||
| User | The name of the user to whom the process belongs. | |||||||||||||||||||||||||||||||||||||||
| Parent PID | The process identifier for the process that is the parent of the specified process. | |||||||||||||||||||||||||||||||||||||||
| Group ID | The group identifier for the user that owns the specified process. | |||||||||||||||||||||||||||||||||||||||
| Processor % | The percentage of CPU time used by the process in the last sample interval. | |||||||||||||||||||||||||||||||||||||||
| Elapsed Time | How long the process has been running. | |||||||||||||||||||||||||||||||||||||||
| Cumulative Time | The amount of CPU time the process has consumed. | |||||||||||||||||||||||||||||||||||||||
| State |
The state of the process. Process states are platform dependent.
| |||||||||||||||||||||||||||||||||||||||
| Terminal | The Unix terminal session where a user started the specified process. If the process was not started by an interactive user, the Terminal value is set to "?". | |||||||||||||||||||||||||||||||||||||||
| Priority | The basic priority assigned to the process – the lower the number, the higher the priority. Unix can modify this priority by means of the renice command. | |||||||||||||||||||||||||||||||||||||||
| Nice | The Nice value describes the relative priority of the specified process. A process with a low Nice value is running at a higher priority than a process with a high Nice value. | |||||||||||||||||||||||||||||||||||||||
| Virt Mem (MB) | The amount of virtual memory in use by the process, measured in megabytes. | |||||||||||||||||||||||||||||||||||||||
| Physical Mem (MB) | The amount of physical memory in use by the process, measured in megabytes. | |||||||||||||||||||||||||||||||||||||||
| Command | The command executed by the process. |