Maybe the idea can be widened: Can SYSDBA or database owner see the objects
being read or modified in the database with their TID variable. The purpose
is to create the function, allowing SYSDBA or database owner to
commit/rollback specific transaction, he/she didn't started.

P.S. Is it possible to wide USER variable with IP variable for TCP/IP
connection?

"Ann W. Harrison" wrote:

> It would be possible - perhaps even easy - to write a utility function
> that wrote out the id of clients that have held a lock for more than
> 10 seconds. The information is all in the lock table.

--
with respect
Alexander Rabtchevich