Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed databases and rollback segments

Re: Distributed databases and rollback segments

From: Jack Reid <FreeJak_at_pgh.nauticom.net>
Date: 1997/04/28
Message-ID: <336533AE.6A42@pgh.nauticom.net>#1/1

Scott;
  I just had to solve this problem. I don't think you'll like the answer. The rollback segment on the remote instance is used and you *can't* pick which one via "SET TRANSACTION...". I had to increase the size of all our rollback segments. Another reason why rb's are called the problem children of Oracle.
  If you get a better idea about how to do this, I'd be very happy to hear about it.

Jack Reid
Principal
Stirling Enterprises, Inc. Received on Mon Apr 28 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US