Provides statistical information regarding objects that have been accessed by processes. monProcessObject requires the enable monitoring and per object statistics active configuration parameters to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
KPID |
int |
Kernel process identifier |
|
DBID |
int |
Unique identifier for the database where the object resides |
|
ObjectID |
int |
Unique identifier for the object |
|
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 APF buffers read from disk |
DBName |
varchar(30) |
null |
Name of database |
ObjectName |
varchar(30) |
null |
Name of the object |
ObjectType |
varchar(30) |
null |
Type of object |
