Provides statistics for all open objects. Requires the enable monitoring and per object statistics active configuration parameter are enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
DBID |
int |
Unique identifier for the database |
|
ObjectID |
int |
Unique identifier for the object |
|
IndexID |
int |
Unique identifier for the index |
|
LogicalReads |
int |
counter |
Total number of buffers read |
PhysicalReads |
int |
counter |
Number of buffers read from disk |
APFReads |
int |
counter |
Number of APF buffers read |
PagesRead |
int |
counter |
Total number of pages read |
PhysicalWrites |
int |
counter |
Total number of buffers written to disk |
PagesWritten |
int |
counter |
Total number of pages written to disk |
RowsInserted |
int |
null, counter |
Number of rows inserted |
RowsDeleted |
int |
null, counter |
Number of rows deleted |
RowsUpdated |
int |
null, counter |
Number of updates |
Operations |
int |
null, counter |
Number of times that the object was accessed |
LockRequests |
int |
null, counter |
Number of requests for a lock on the object |
LockWaits |
int |
null, counter |
Number of times a task waited for a lock for the object |
