The system table <DATABASE_SYSTEM_ADMINITRATOR>.HISTORYINFO displays information regarding data history. This history is necessary for providing data for a consistent view.
FILENO |
FIXED(10) |
Number of the history file |
FIRSTTRANS |
CHAR(20) |
Oldest transaction that has not yet been processed by the garbage collector |
LASTTRANS |
CHAR(20) |
Most recent transaction that has not yet been processed by the garbage collector |
PAGECOUNT |
FIXED(10) |
Number of pages used by the history file and all undo log files referenced by it |