Re: Question about Rollback Segments

Stuart,
The first insert is the start of the ORACLE transaction and will use the same rollback segment until the ORACLE transaction ends. The ORACLE transaction ends when a COMMIT or ROLLBACK is given.

From that point on, you are now in another ORACLE transaction. You cannot have multiple COMMITs in the same ORACLE transaction. So the next ORACLE transaction will use another (or even the same) rollback segment.

You assume that one of your transactions (inserting lots of rows into a table in chunks of 500,000) is one ORACLE transaction but it isn't.

Hope this helps.
--
Regards Pete
stuco_at_mailcity.com wrote in message <6tjd7d$1ms$1_at_nnrp1.dejanews.com>...
>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 Thu Sep 24 1998 - 08:25:14 CDT