What you could do is configure the listener to have a timeout value of 5min
or so. By default it listens indefinetly, probably meaning that if a client
process dies abnormally it doesn't detect it.
Pat Minnis <pminnis_at_maverick.net> schreef in artikel
<Gdp33.1824$S4.10542_at_news.goodnet.com>...
> I don't think a rollback can be sped up so easily, but resource limits
using
> profiles could stop super long queries that never commit until next week
:-)
>
> <scooby_fudge_at_my-dejanews.com> wrote in message
> news:7ieakg$s4r$1_at_nnrp1.deja.com...
> > Is there any way of speeding up the time it takes
> > for Oracle to rollback transactions from user
> > processes which have died abnormally ?
> >
> > Is there an INIT.ORA parameter to control this, or
> > maybe it's an SQL*Net setting ?
> >
> > Thanks in advance for your help !
> >
> >
> > --== Sent via Deja.com http://www.deja.com/ ==--
> > ---Share what you know. Learn what you don't.---
>
>
>
Received on Fri May 28 1999 - 05:05:15 CDT
