MULTIVERSIONREADSTATISTICS
The system table SYSINFO.MULTIVERSIONREADSTATISTICS
provides
details about operations for preserving consistent reading since the last
start of the database instance.
|
FIXED(15) |
ID of the oldest transaction for which the history data has to be retained |
|
CHAR(3) |
Retain the history data for the transactions started after the transaction indentified via MINTRANSACTIONID (YES | NO) |
|
FIXED(20) |
Number of pages whose entry points into history data had to be recreated via additional page access |
|
FIXED(20) |
Number of pages whose entry points into history data could be created directly from the page |
|
FIXED(20) |
Number of pages whose entry points into history data had to be stored on an additional page while writing |
|
FIXED(20) |
Number of pages whose entry points into history data could be stored on the page itself while writing |
|
FIXED(20) |
Number of accesses to history data |
|
FIXED(3) |
Percentage of pages to be written that have to be copied before being written to the memory (%) |