>> * 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