Re: detecting long-running transactions?
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 16 May 2009 08:40:31 +0200
Message-ID: <4a0e5fdd$0$27392$426a34cc_at_news.free.fr>
Date: Sat, 16 May 2009 08:40:31 +0200
Message-ID: <4a0e5fdd$0$27392$426a34cc_at_news.free.fr>
<mh_at_pixar.com> a écrit dans le message de news: 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
v$transaction.start_time
Regards
Michel
Received on Sat May 16 2009 - 01:40:31 CDT