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 -> Re: Rollback question

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

Original text of this message

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