Provides identifying information about each process on the server. See “monProcessActivity” for statistics about the activity of each process.
You need not enable any configuration parameters for
this monitoring table to collect data.
The columns for monProcessLookup are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
InstanceID |
int |
Specific to cluster environments – ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier |
|
Login |
varchar(30) |
Null |
Login user name |
Application |
varchar(30) |
Null |
Application name |
ClientHost |
varchar(30) |
Null |
Host name of client |
ClientIP |
varchar(24) |
Null |
IP address of client |
ClientOSPID |
varchar(30) |
Null |
Client application’s operating system process identifier |
