| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback question
On Mon, 24 Jan 2005 11:49:58 -0500, "Syltrem"
<syltremzulu_at_videotron.ca> wrote:
>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.
Your expectation is wrong. When a session is killed, it's transaction is aborted and immediately cleared from v$transaction. Then Oracle's *background processes* start rolling back the transaction.
>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 - 12:36:44 CST
 |
 |