Question about Rollback Segments

From: John Harris <jharri_at_sapient.com>
Date: Mon, 14 Sep 1998 15:04:25 -0400
Message-ID: <0685A427A719D11197BB00A024D399450850CF98@delphi.sapient.com>

Oracle will move on to the next rollback segment. If you want oracle to use a particular
rollback segment then you must explicitly state the rollback segment you want using the
alter session command

alter session use rollback segment xxx;

this code should be placed immediately after the commit from the previous transaction.

-----Original Message-----

		From:	stuco_at_mailcity.com [mailto:stuco_at_mailcity.com]
		Posted At:	Monday, September 14, 1998 8:38 AM
		Posted To:	misc
		Conversation:	Question about Rollback Segments
		Subject:	Question about Rollback Segments

		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 - 14:04:25 CDT