At 08:47 PM 15/03/2006, you wrote:

>I am experiencing problem with processor alerts caused by Firebird.

Never heard of such a thing. What does a processor alert look
like? What platform?

>I understand this probably caused by a fualty query,

What was the source for that information? A faulty query will throw
an exception or just run forever and/or, ultimately, use up all
resources, e.g insert into tablea (a,b,c) select a,b,c from tablea.

>Can anyone suggest a tool that would enable me to monitor what is
>happening on FB to try to detect the errant query?

Try asking on firebird-tools.

./hb