Maybe this can help: SELECT st.mon$statement_id as "Statement ID",
st.mon$attachment_id as "Attachment ID", st.mon$transaction_id "Transaction ID", case when st.mon$state = 0 then 'IDLE' when st.mon$state = 1 then 'ACTIVE' end as "State", st.mon$timestamp "Started At", st.mon$sql_text "Statement Text", r.mon$record_seq_reads as "Non-indexed Reads", r.mon$record_idx_reads as "Indexed Reads", r.mon$record_inserts as "Records Inserted", r.mon$record_updates as "Records Updated", r.mon$record_deletes as "Records Deleted", r.mon$record_backouts as "Records Backed Out", r.mon$record_purges as "Records Purged", r.mon$record_expunges as "Records Expunged", io.mon$page_reads as "Page Reads", io.mon$page_writes as "Page Writes", io.mon$page_fetches as "Page Fetches", io.mon$page_marks as "Page Marks" FROM mon$statements st left join mon$record_stats r on (st.mon$stat_id = r.mon$stat_id) left join mon$io_stats io on (st.mon$stat_id = io.mon$stat_id) where st.mon$state=1 order by st.mon$timestamp De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Enviada em: segunda-feira, 18 de agosto de 2014 14:48 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] object is in use Hello. IBExpert shows the message: lock conflict on no wait transaction unsuccessful metada update object MY_PROCEDURE is in use How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng