Re: transaction and rollback segment

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 26 Oct 1998 20:26:19 -0600
Message-ID: <36352F4B.32936BB4@deere.com>

The rollback segment will continue to grow until the tablespace fills up or the transaction commits or rollbacks. Note that although the one long transaction is keeping the rolback segment from wrapping over itself, other transactions will also be assigned to the particular rollback segment.

Note that a failed user process rolls back the transaction.

On the other hand, the SQL*Plus default is to commit the transaction if you terminate SQL*Plus without a commit or rollback.

Paul Chang wrote:

If you have a transaction but doesn't do commit on it,
what would happen to the rollback segment?
if the transaction is long running and no commit on it,
what would happen to the rollback segment?

thanks,

Paul.

  Received on Mon Oct 26 1998 - 20:26:19 CST