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.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
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 |
