Re: Cursors, rollback and Long Updates

From: Ken Friday <ken.friday_at_teldta.com>
Date: 1995/07/31
Message-ID: <3vjmb9$hf5_at_madison.tdsnet.com>#1/1

Just a thought:

Rollback segments are also used for "read consistancy" which is guaranteed for the life of the open cursor. This means that intermittent commits will not release the rollback segment space.

One suggestion would be to "clone" the driving table. Drive off one then update the other. The restart will probably invlove rebuilding the clone with (NON Y) a subset of the orignal.

Ken Friday Received on Mon Jul 31 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: swong_at_ED.RAY.COM: "PO7-can't connect as internal"
Previous message: User_Organization=ValleyNet: "Re: Cursors, rollback and Long Updates"
In reply to: Simon Thompson: "Cursors, rollback and Long Updates"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message