26.9 Global buffer table (hirBufferStatusTable)

The global buffer table stores performance information collected over a given time period on global buffers. One line is created for each global buffer.

Notes on collecting performance information
Set the performance information collection interval to no less than 60 seconds so that HiRDB performance is not affected adversely.

Table 26-7 shows the configuration of the global buffer table.

Table 26-7 Configuration of the global buffer table

IDObjectExplanationTypePrivilegeData source
6.hirBufferStatusTable Global buffer tableSEQUENCEnot-access[Figure]
6.1hirBufferStatusEntryGlobal buffer entrySEQUENCEnot-access[Figure]
6.1.1hirBufferStatusSysIndexHiRDB system identifier indexINTEGERread-onlyMIB command
6.1.2hirBufferStatusBufferIndexGlobal buffer identifier indexINTEGERread-onlyMIB command
6.1.3hirBufferStatusInstanceInstance name
HiRDB-identifier:server-name:global-buffer-name
Display
String
read-onlyMIB command
6.1.4hirBufferStatusHirIDHiRDB identifierDisplay
String
read-onlyMIB command
6.1.5hirBufferStatusBufferNameGlobal buffer nameDisplay
String
read-onlypdbufls -k sts -d
6.1.6hirBufferStatusBufferPoolHitRateGlobal buffer pool hit rate (%)INTEGERread-onlypdbufls -k sts -d
6.1.7hirBufferStatusCurrentReferenceBuffersCurrent number of reference buffersINTEGERread-onlypdbufls -k sts -d
6.1.8hirBufferStatusCurrentUpdateBuffersCurrent number of update buffersINTEGERread-onlypdbufls -k sts -d
6.1.9hirBufferStatusDBSyncsNumber of synchronization points that have occurredGaugeread-onlypdbufls -k sts -d
6.1.10hirBufferStatusLOBBufferInputPagesNumber of LOB buffer batch input pagesGaugeread-onlypdbufls -k sts -d
6.1.11hirBufferStatusLOBBufferOutputPagesNumber of LOB buffer batch output pagesGaugeread-onlypdbufls -k sts -d
6.1.12hirBufferStatusLOBBufferReadRequestsNumber of LOB buffer read requestsGaugeread-onlypdbufls -k sts -d
6.1.13hirBufferStatusLOBBufferWriteRequestsNumber of LOB buffer write requestsGaugeread-onlypdbufls -k sts -d
6.1.14hirBufferStatusOutOfBufferNumber of times buffer shortage occurredGaugeread-onlypdbufls -k sts -d
6.1.15hirBufferStatusPrefetchBufferShortagesNumber of times prefetch buffer shortage occurredGaugeread-onlypdbufls -k sts -d
6.1.16hirBufferStatusPrefetchHitRatePrefetch hit rate (%)INTEGERread-onlypdbufls -k sts -d
6.1.17hirBufferStatusPrefetchInputPagesNumber of prefetch input pagesGaugeread-onlypdbufls -k sts -d
6.1.18hirBufferStatusPrefetchReadRequestsNumber of prefetch read requestsGaugeread-onlypdbufls -k sts -d
6.1.19hirBufferStatusReadsNumber of real read requests from diskGaugeread-onlypdbufls -k sts -d
6.1.20hirBufferStatusReferenceBufferFlushesNumber of reference buffer flushesGaugeread-onlypdbufls -k sts -d
6.1.21hirBufferStatusReferenceGetsNumber of reference GETsGaugeread-onlypdbufls -k sts -d
6.1.22hirBufferStatusReferenceHitRateReference request hit rateINTEGERread-onlypdbufls -k sts -d
6.1.23hirBufferStatusServerNameServer nameDisplay
String
read-onlypdbufls -k sts -d
6.1.24hirBufferStatusUpdateBufferFlushesNumber of update buffer flushesGaugeread-onlypdbufls -k sts -d
6.1.25hirBufferStatusUpdateGetsNumber of update GETsGaugeread-onlypdbufls -k sts -d
6.1.26hirBufferStatusUpdateHitRateUpdate request hit rate (%)INTEGERread-onlypdbufls -k sts -d
6.1.27hirBufferStatusUpdatedBufferTriggerNumber of update buffers that become output triggers during deferred write triggersINTEGERread-onlypdbufls -k sts -d
6.1.28hirBufferStatusWaitsNumber of times buffer lock-release wait occurredGaugeread-onlypdbufls -k sts -d
6.1.29hirBufferStatusWritesNumber of real write operations to diskGaugeread-onlypdbufls -k sts -d
6.1.30hirBufferStatusDummyCannot be referenced.INTEGERread-onlyMIB command

Legend:

[Figure]: Not applicable