Discussion:
[Firebird-docs] Clarification for MON$RECORD_STATS
Paul Beach
2016-12-19 12:10:18 UTC
Permalink
From Helen's bible...
1. MON$RECORD_BACKOUTS

Number of records where a new primary record version is
backed out due to a rollback or savepoint undo

2. MON$RECORD_PURGES

Number of records where the record version chain is being
purged of versions no longer needed by OAT or younger transactions

3. MON$RECORD_EXPUNGES

Number of records where record version chain is being deleted due
to deletions by transactions older than the OAT

Where OAT = Oldest Active Transaction.

Paul

Loading...