Fragment metrics

The onperf utility can display metrics for an individual table fragment.

These metrics take the dbspace of an individual table fragment as the metric scope.
Metric Name Description
Lock Requests Total requests to lock fragment
Lock Waits Number of times that threads have waited to obtain a lock for the fragment
Deadlocks Number of times that a deadlock involved the fragment
Deadlock Timeouts Number of times that a deadlock timeout involved the fragment
Reads Number of read calls that involve the fragment
Writes Number of write calls that involve the fragment
Rewrites Number of rewrite calls that involve the fragment
Deletes Number of delete calls that involve the fragment
Calls Total calls that involve the fragment
Buffer Reads Number of buffer reads that involve fragment data
Buffer Writes Number of buffer writes that involve fragment data
Sequential Scans Number of sequential scans of the fragment
Percent Free Space Percent of the fragment that is free
Pages Allocated Number of pages allocated to the fragment
Pages Used Number of pages allocated to the fragment that have been written to
Data Pages Number of pages allocated to the fragment that are used as data pages