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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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.
| ||||||||||
|
% 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.