Re: Question about Rollback Segments
Date: 14 Sep 1998 18:10:23 GMT
Message-ID: <6tjm6f$jul$1_at_brokaw.wa.com>
It grabs the first available rollback segment after each commit. Your only work-around is to make sure that your big rollback segment is the first one available.
stuco_at_mailcity.com wrote:
: I do large loads using Pro*C programs with Embedded SQL and I COMMIT after
: every 500,000 rows.
:
: The program sets the transaction to use a large rollback segment, then INSERTs
: data using bind variables.
:
: After the first COMMIT, will my program still use the rollback segment I told
: it to use, or will it randomly select another?? Remember, there are multiple
: commits within the same transaction.
:
: Thanking all of you for your valuable assistance.
:
: Stuart L. Cowen
: Paladin Consulting - Dallas
:
: -----== Posted via Deja News, The Leader in Internet Discussion ==-----
: http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 14 1998 - 20:10:23 CEST