Re: distributed transaction detecting

When you say "remote machine", you mean "remote database", not a remote client? Then the only thing I can think of for now is select current_utilization from v$resource_limit where resource_name = 'distributed_transactions'. If it's not 0, there must be one such transaction.

If you know from what databases these transactions could come from, you can monitor v$lock on those databases for type = 'DX'.

Yong Huang
yong321_at_yahoo.com

olaf_at_raether.de (Olaf Raether) wrote in message news:<8b55fad6.0203220947.19278b61_at_posting.google.com>...
> Hey,
> hey is it possible to detect an distributed transaction ?
>
> i want to detect, if an insert, update or delete is comming
> from a remote machine.
>
> thanks
>
> Olaf Raether
Received on Sun Mar 24 2002 - 15:50:14 CST