Session metrics
The onperf utility can display metrics for an active session.
These metrics take the active session as the metric scope.
| Metric Name | Description |
|---|---|
| Page Reads | Number of pages read from disk on behalf of a session |
| Page Writes | Number of pages written to disk on behalf of a session |
| Number of Threads | Number of threads currently running for the session |
| Lock Requests | Number of lock requests issued by the session |
| Lock Waits | Number of lock waits for session threads |
| Deadlocks | Number of deadlocks involving threads that belong to the session |
| Deadlock timeouts | Number of deadlock timeouts involving threads that belong to the session |
| Log Records | Number of log records written by the session |
| ISAM Calls | Number of ISAM calls by session |
| ISAM Reads | Number of ISAM read calls by session |
| ISAM Writes | Number of ISAM write calls by session |
| ISAM Rewrites | Number of ISAM rewrite calls by session |
| ISAM Deletes | Number of ISAM delete calls by session |
| ISAM Commits | Number of ISAM commit calls by session |
| ISAM Rollbacks | Number of ISAM rollback calls by session |
| Long Transactions | Number of long transactions owned by session |
| Buffer Reads | Number of buffer reads performed by session |
| Buffer Writes | Number of buffer writes performed by session |
| Log Space Used | Amount of logical-log space used |
| Maximum Log Space Used | High-watermark of logical-log space used for this session |
| Sequential Scans | Number of sequential scans initiated by session |
| PDQ Calls | Number of parallel-processing actions performed for queries initiated by the session |
| Memory Allocated | Memory allocated for the session in kilobytes |
| Memory Used | Memory used by the session in kilobytes |