Re: Rollback question

From: Alan <not.me_at_rcn.com>
Date: Mon, 24 Jan 2005 12:11:52 -0500
Message-ID: <35kp0pF4mq1e6U1@individual.net>

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news:IF9Jd.2429$df.102832_at_tor-nn1.netcom.ca...
> Hi
>
> I had to kill a user that had about 5.5 GB used up in the rollback segment
> (as per v$transaction).
> I was expecting to follow the progress of the rollback with v$transaction,
> but I cannot see the transaction anymore.
>
> I can't see how such a transaction could have rolled back in less than 5
> seconds.
>
> Any hints appreciated.
>
> --
> Syltrem
>
> OpenVMS 7.3-1 + Oracle 8.1.7.4
> http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
> ---zulu is not in my email address---
>
>

Perhaps it committed before you could kill it. Received on Mon Jan 24 2005 - 11:11:52 CST