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

Rollback question

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Mon, 24 Jan 2005 11:49:58 -0500
Message-ID: <IF9Jd.2429$df.102832@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---
Received on Mon Jan 24 2005 - 10:49:58 CST

Original text of this message

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