firebird-docs

[Firebird-docs] Clarification for MON$RECORD_STATS

[Köditz, M. <Mar...@it...>]

Hi,

currently I translate the chapter about monitoring tables. I'm a bit confused in section MON$RECORD_STATS.
Please show the differences of following columns:

1.       MON$RECORD_BACKOUTS

2.       MON$RECORD_PURGES

3.       MON$RECORD_EXPUNGES
I need more details here. Especially for MON$RECORD_PURGES and MON$RECORD_EXPUNGES. In German it means almost DELETE. But I think there is a huge difference to MON$RECORD_DELETES.

Regards
Martin

Re: [Firebird-docs] Clarification for MON$RECORD_STATS

[Paul B. <pb...@ib...>]

>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