====== Monitoring ======

[[https://sodocumentation.net/firebird/topic/5145/monitoring|Firebird Tutorial - Monitoring]]

===== Transactions en attente de nettoyage =====

<code sql>
SELECT
  d.MON$OLDEST_TRANSACTION,
  d.MON$OLDEST_ACTIVE,
  d.MON$OLDEST_SNAPSHOT,
  d.MON$NEXT_TRANSACTION - 1 - d.MON$OLDEST_ACTIVE AS NB_AWAITING_GC
FROM MON$DATABASE d
</code>

=> Renvoie le nombre de transaction "Awaiting GC"