|Subject||RE: [firebird-support] system table behaviour|
‘Tis starting to make some sense now.
Unfortunately our application establishes a connection to the FB server and remains active until shut down. I can’t terminate it and create a new one. A ‘feature’ of the RAD we are using.
You have given me an idea though, thanks.
Sent: Thursday, 4 February 2016 3:31 PM
Subject: Re: [firebird-support] system table behaviour
You don't have to close the application to refresh the MON$ results,
simply commit the transaction and run the query in a new transaction.
The MON4 tables are in-memory structures. Queries on them run in a
SNAPSHOT transaction. That is, the statement provides a snapshot of
the status of those items at the time the transaction started and will
not be "refreshed" by re-running the same query inside the same
The persistent system tables (RDB$...) behave like any regular table.