detecting long-running transactions?

From: <mh_at_pixar.com>
Date: Fri, 15 May 2009 23:23:32 GMT
Message-ID: <UPmPl.16668$pr6.3562_at_flpi149.ffdc.sbc.com>



Is it possible to detect long-running transactions?

We would like to automatically catch the cases where some (for example) makes a change with Sql Developer, forgets to commit, and then leaves for the evening.

tia!
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Fri May 15 2009 - 18:23:32 CDT

Original text of this message