Clarification for MON$RECORD_STATS

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Clarification for MON$RECORD_STATS

Köditz, Martin

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

 


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-docs mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Clarification for MON$RECORD_STATS

Paul Beach
>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


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-docs mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Clarification for MON$RECORD_STATS

Köditz, Martin
In reply to this post by Köditz, Martin

Ah, makes things clearer.

 

Thank you, Paul.


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-docs mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Loading...