>> * other interesting requests ? to prevent or diagnose quickly problems ?
>
> I sometimes use (well, I don't actually include any ORDER BY, but would if there were lots of simultaneous activity going on)
>
> select <whatever>
> from mon$statements
> where mon$transaction_id <> current_transaction
> order by mon$timestamp
>
> to find statements that are currently running (typically statements that I've issued without taking a proper look on the plan or where I notice an error while it is executing so that I want to terminate that particular request). I think it could be used to find candidates for being long-running queries. Though I use Fb 2.5 and don't know whether it will work or not on 2.1.

This particular statement will work in 2.1. ;-)


Thomas