Subject Re: [firebird-support] Connected users from MON$ATTACHMENT
Author Thomas Steinmaurer
> Hello!
> May I use the system table "MON$ATTACHMENT" in order to get the connected
> users in moment?
> I already try to do it, but when a connection from a client (another
> machine) is ended abnormally (for example, turn off the machine or
> disconnect the cable of network), this connection still stay on system
> There are a way to "refresh" this system table?

Does it help when you query the monitoring tables in a new transaction context?

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.