>> If your database has an ODS of at least 11.1, then you can do:
>>
>> select
>> a.*
>> , t.*
>> from
>> mon$transactions t join mon$attachments a on (t.mon$attachment_id =
>> a.mon$attachment_id)
>> where
>> mon$transaction_id = 7850179
>>
>> This will give the transaction and attachment information for this
>> particular transaction id.
>>
>> You can also look up the statements associated to this transaction id by
>> executing:
>>
>> select * from mon$statements where mon$transaction_id = 7850179
>>
>>> I cannot shutdown and restart the database at the moment, as it is during
>>> production hours.
>>
>> It shouldn't be necessary. It's also possible to kill a particular
>> statement by executing a DELETE statement on the MON$STATEMENTS table.
>>
>> --
>> With regards,
>> Thomas Steinmaurer (^TS^)
>> Firebird Technology Evangelist
>>
>> http://www.upscene.com/
>>
>> Do you care about the future of Firebird? Join the Firebird Foundation:
>> http://www.firebirdsql.org/en/firebird-foundation/
>
>
>
> Thank you Thomas for the quick response.
>
> I have executed the first query you have provided, and it pin pointed the
> user. Exactly what I wanted thanks for that.
>
> I then tried the second query " select * from mon$statements where
> mon$transaction_id = 7850179" but there is nothing in the result set.

This is expected, if any statement in context of this transaction is
finished, but the transaction is still alive, because you can start
transaction without executing any statements.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/

> I
> asked the particular user to restart his machine, and everything is back to
> normal now.
>
> Thanks again for your help.
>
>
> Regards
> Marius
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>