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

OS Processes Page

The operating system on the host machine provides Oracle with key resources such as CPU, memory, disk I/O, and network access. Shortfalls in any of these resources may affect the overall performance of your Oracle system.

While you can see statistics on operating-system resources that may cause performance bottlenecks in the OS Performance Page, you can use the grid in this page to view statistics on the processes that are using those resources.

To open the OS Processes page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Operating System | OS Processes.

Tip: To open the related Spotlight on Windows or Spotlight on Unix connection, click the arrow next to the Operating System drilldown icon.

Grid on the OS Processes Page

Column Description

Process ID

The process identifier for the database machine operating system.

Command

A description of the command being run.

% User

The percentage of time spent by this process in user mode. This column does not display data when you are analyzing a database running on Unix.

% Privileged

The percentage of time spent by this process in privileged mode. This column does not display data when you are analyzing a database running on Unix.

Virt. Mem. (MB)

The amount of virtual memory used by the process.

Work set (MB)

The amount of physical memory used by the process.

Priority

The number allocated by the operating system based on the urgency or priority for this process.

Page faults/s

The number of page faults per second. This column does not display data when you are analyzing a database running on Unix.

Start time

The date and time at which this process started.

CPU Time

The amount of CPU time the process has consumed.

Operating System Measure
Oracle Solaris The cumulative execution time for the process.
HP-UX The cumulative execution time for the process.
IBM AIX

The cumulative CPU time since the process started.

The display format is [[ dd-]hh:]mm:ss, where dd specifies the number of days, hh specifies the number of hours, mm specifies the number of minutes, and ss specifies the number of seconds.

Linux

The accumulated CPU time (user and system).

The display format is usually MMM:SS, but can be shifted to the right if more than 999 minutes of CPU time is used.

% Processor

The percentage of the CPU being used by this process.

Handles

The number of handles used for this process. This column does not display data when you are analyzing a database running on Unix.

Threads

The number of threads used for this process. This column does not display data when you are analyzing a database running on Unix.

User

The owner of this process.

Notes:

  • Differences between versions of operating systems mean that Spotlight is unable to collect all O/S statistics in all environments. Operating System Connection / Statistics lists statistics that are not reported by Spotlight on Oracle for each operating system.
  • For Oracle databases on Unix Servers: Right click an Oracle process and select Top Sessions to open the Top Sessions drilldown. If the process is not an Oracle process you will see the error: Unable to find Oracle session for this process.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating