Subject Number of transactions by selected user
Author hamacker
To get number of connections by selected user:
SELECT count(*)  FROM MON$ATTACHMENTS a 
WHERE a.MON$USER='sysdba'

But If I need number of transactions pending, is it possible?