Nonstop Database, HiRDB Version 9 System Operation Guide
The global buffer table stores performance information collected over a given time period on global buffers. One line is created for each global buffer.
The following table shows the configuration of the global buffer table.
Table 27-7 Configuration of the global buffer table
ID | Object | Explanation | Type | Privilege | Data source |
---|---|---|---|---|---|
6. | hirBufferStatusTable | Global buffer table | SEQUENCE | not-access | -- |
6.1 | hirBufferStatusEntry | Global buffer entry | SEQUENCE | not-access | -- |
6.1.1 | hirBufferStatusSysIndex | HiRDB system identifier index | INTEGER | read-only | MIB command |
6.1.2 | hirBufferStatusBufferIndex | Global buffer identifier index | INTEGER | read-only | MIB command |
6.1.3 | hirBufferStatusInstance | Instance name HiRDB-identifier:server-name:global-buffer-name |
Display String | read-only | MIB command |
6.1.4 | hirBufferStatusHirID | HiRDB identifier | Display String | read-only | MIB command |
6.1.5 | hirBufferStatusBufferName | Global buffer name | Display String | read-only | pdbufls -k sts -d |
6.1.6 | hirBufferStatusBufferPoolHitRate | Global buffer pool hit rate (%) | INTEGER | read-only | pdbufls -k sts -d |
6.1.7 | hirBufferStatusCurrentReferenceBuffers | Current number of reference buffers | INTEGER | read-only | pdbufls -k sts -d |
6.1.8 | hirBufferStatusCurrentUpdateBuffers | Current number of update buffers | INTEGER | read-only | pdbufls -k sts -d |
6.1.9 | hirBufferStatusDBSyncs | Number of synchronization points that have occurred | Gauge | read-only | pdbufls -k sts -d |
6.1.10 | hirBufferStatusLOBBufferInputPages | Number of LOB buffer batch input pages | Gauge | read-only | pdbufls -k sts -d |
6.1.11 | hirBufferStatusLOBBufferOutputPages | Number of LOB buffer batch output pages | Gauge | read-only | pdbufls -k sts -d |
6.1.12 | hirBufferStatusLOBBufferReadRequests | Number of LOB buffer read requests | Gauge | read-only | pdbufls -k sts -d |
6.1.13 | hirBufferStatusLOBBufferWriteRequests | Number of LOB buffer write requests | Gauge | read-only | pdbufls -k sts -d |
6.1.14 | hirBufferStatusOutOfBuffer | Number of times buffer shortage occurred | Gauge | read-only | pdbufls -k sts -d |
6.1.15 | hirBufferStatusPrefetchBufferShortages | Number of times prefetch buffer shortage occurred | Gauge | read-only | pdbufls -k sts -d |
6.1.16 | hirBufferStatusPrefetchHitRate | Prefetch hit rate (%) | INTEGER | read-only | pdbufls -k sts -d |
6.1.17 | hirBufferStatusPrefetchInputPages | Number of prefetch input pages | Gauge | read-only | pdbufls -k sts -d |
6.1.18 | hirBufferStatusPrefetchReadRequests | Number of prefetch read requests | Gauge | read-only | pdbufls -k sts -d |
6.1.19 | hirBufferStatusReads | Number of real read requests from disk | Gauge | read-only | pdbufls -k sts -d |
6.1.20 | hirBufferStatusReferenceBufferFlushes | Number of reference buffer flushes | Gauge | read-only | pdbufls -k sts -d |
6.1.21 | hirBufferStatusReferenceGets | Number of reference GETs | Gauge | read-only | pdbufls -k sts -d |
6.1.22 | hirBufferStatusReferenceHitRate | Reference request hit rate | INTEGER | read-only | pdbufls -k sts -d |
6.1.23 | hirBufferStatusServerName | Server name | Display String | read-only | pdbufls -k sts -d |
6.1.24 | hirBufferStatusUpdateBufferFlushes | Number of update buffer flushes | Gauge | read-only | pdbufls -k sts -d |
6.1.25 | hirBufferStatusUpdateGets | Number of update GETs | Gauge | read-only | pdbufls -k sts -d |
6.1.26 | hirBufferStatusUpdateHitRate | Update request hit rate (%) | INTEGER | read-only | pdbufls -k sts -d |
6.1.27 | hirBufferStatusUpdatedBufferTrigger | Number of update buffers that become output triggers during deferred write triggers | INTEGER | read-only | pdbufls -k sts -d |
6.1.28 | hirBufferStatusWaits | Number of times buffer lock-release wait occurred | Gauge | read-only | pdbufls -k sts -d |
6.1.29 | hirBufferStatusWrites | Number of real write operations to disk | Gauge | read-only | pdbufls -k sts -d |
6.1.30 | hirBufferStatusDummy | Cannot be referenced. | INTEGER | read-only | MIB command |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.