From: "Robert Yeh" <robert.yeh@qwest.com>
Newsgroups: comp.databases.oracle.server
Subject: select statement to remote database use rollback seg.
Date: Wed, 6 Jun 2001 17:11:04 -0400
Lines: 7
Message-ID: <9fm61d$3dd$1@bob.news.rcn.net>
X-Trace: UmFuZG9tSVbKFqOK43UX1jUf3ydkia6J/5QDFRn7MX+q2T/LB72lLBg0ttXiMnD0
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 6 Jun 2001 21:06:53 GMT
X-MimeOLE:  Produced By Microsoft MimeOLE V4.72.3110.3
X-Newsreader:  Microsoft Outlook Express 4.72.3110.5


Does anyone know why does a select statement that involve a remote database
use rollback segment?  What is stored in the rollback segment?  Does the
rollback segment keep growing after the creation?

Thanks