Re: Question about Rollback Segments

True.

But if you are able to take the other segments off-line, then your 'business transaction' will have no choice but to use your large rollback segment, without the need to specify it.

Rgds
allan.webster_at_pancredit.com

> ----------
> From: John P. Higgins[SMTP:jh33378_at_deere.com]
> Posted At: Monday, September 14, 1998 5:30 PM
> Posted To: server
> Conversation: Question about Rollback Segments
> Subject: Re: Question about Rollback Segments
>
> This is the difference between a 'business' transaction and a
> 'database' transaction.
>
> A commit explicitly ends a database transaction.
>
> If you want to continue to use a specified rollback segment, you must
> set it again after every commit.
>
> 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 Tue Sep 15 1998 - 10:38:33 CDT