|Subject||Question about gathering Metadata in Firebird|
I am new in Firebird. I would like to gather Metadata about queries in Firebird ( something like this in MSSQ )
I have just found Monitoring Tables in Firebird, which have intersteing information for me, but the problem there is no same column in MON$IO_STATS and (MON$TRANSACTIONS and MON$STATEMENTS )
If I run such a query, I am getting no resualt:
SELECT * from MON$TRANSACTIONS as T INNER JOIN MON$IO_STATS as IO on ( T.MON$STAT_ID=IO.MON$STAT_ID) INNER JOIN MON$STATEMENTS as S on(S.MON$STAT_ID=T.MON$STAT_ID)
Would you please say me, how can I gather Meadata about queries in Firebird?