Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lost Connection Detection
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 Thu May 27 1999 - 23:44:55 CDT