Xref: alice comp.databases.oracle.server:42138
Path: alice!news-feed.fnsi.net!netnews.com!nntp.abs.net!newshub2.home.com!newshub1.home.com!news.home.com!news.rdc1.az.home.com.POSTED!not-for-mail
From: "Kevin P. Fleming" <kfleming@access-laserpress.com>
Newsgroups: comp.databases.oracle.server
References: <7bjptp$fqc9@cns.compuware.com>
Subject: Re: Rollback Segnments: Public or Private?
Lines: 45
Organization: Access Laserpress, Inc.
MIME-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <fDgD2.3765$7L.750@news.rdc1.az.home.com>
Date: Wed, 03 Mar 1999 20:06:35 GMT
X-Complaints-To: abuse@home.net
X-Trace: news.rdc1.az.home.com 920491595 209.125.46.226 (Wed, 03 Mar 1999 12:06:35 PDT)
NNTP-Posting-Date: Wed, 03 Mar 1999 12:06:35 PDT

PUBLIC is the easiest, in a non Parallel Server environment, because you can
create more of them on the fly and not have to worry about editing your
INIT.ORA file so they get enabled the next the server is restarted...

PRIVATE would really only be used in a Parallel Server environment, I
believe. There it's mandatory, Parallel Server instances can't use PUBLIC
rollback segments at all.

Bill Fee wrote in message <7bjptp$fqc9@cns.compuware.com>...
>Hello,
>
>I have a question on whether to create rollback segments as PUBLIC or
>PRIVATE?
>
>I read that you only create ‘PUBLIC’ rollback segments in a parallel server
>configuration. ( I am not using a parallel server cobfiguration.)
>
>When I restart the instance only the PUBLIC rollback segments that were on
>line come up in a online status.
>
>I also read that you can place PRIVATE rollback segments in the
>INIT<SID>.ORA that will come on online with instance startup.
>ROLLBACK_SEGMENTS = (segment_name, segment_name,.....)
>
>My question is it common practice to:
>1) Make your rollback segments PUBLIC
>OR
>2) Make your rollback segments PRIVATE and place them in the INIT<SID>.ORA
>file
>OR
>3) Make your rollback segments PRIVATE and bring them online as you need
>them after instance startup
>
>At the moment I am making all my rollback segments as PUBLIC.
>
>Thanks in advance,
>
>A newbie,
>
>Bill Fee
>
>
>
>