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