Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dead transactions

Dead transactions

From: Bruinjoe <bruinjoe_at_aol.com>
Date: 1997/06/13
Message-ID: <19970613211301.RAA28168@ladder02.news.aol.com>#1/1

Is there a way of forcing the DBMS to drop dead transactions. It would be nice if we could get the database to check every five minutes. We have users who will ALT-CNTL-DLT instead of waiting for long running jobs to complete. This leaves the transaction hanging. Oracle will eventually drop the transaction but it could be fifteen or thirty minutes before the transaction is dropped. Is there a way to speed up this process.

Thanks in advance. Received on Fri Jun 13 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US