Provides statistical information regarding objects currently being accessed by processes.
Enable the enable monitoring and per object statistics active configuration parameters for this monitoring table to collect data.
The columns for monProcessObject are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier |
|
DBID |
int |
Unique identifier for the database in which the object resides |
|
ObjectID |
int |
Unique identifier for the object |
|
PartitionID |
int |
Unique identifier for the partition |
|
IndexID |
int |
Unique identifier for the index |
|
OwnerUserID |
int |
User identifier for the object owner |
|
LogicalReads |
int |
Counter |
Number of buffers read from cache |
PhysicalReads |
int |
Counter |
Number of buffers read from disk |
PhysicalAPFReads |
int |
Counter |
Number of asynchronous prefetch buffers read from disk |
DBName |
varchar(30) |
Null |
Name of database |
ObjectName |
varchar(30) |
Null |
Name of the object |
PartitionName |
varchar(30) |
Null |
Name of the partition |
ObjectType |
varchar(30) |
Null |
Type of object |
PartitionSize |
int |
Counter, null |
Partition size in kilobytes |
