Re: Public vs Private Rollback Segments

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 17 Feb 1999 10:17:03 -0800
Message-ID: <36CB079F.132F211F@us.oracle.com>

Alex

Manageability was probably the wrong word. What I meant was that the DBA has easier control over the number of rollback segments and when they start up when you use private ones vs when you use public ones.

HTH. Pete

Alex Hudghton wrote:

> Pete
>
> How is there more manageability in a single instance situation??
>
> Alex
>
> Peter Sharman wrote:
>
> > John
> >
> > This is actually incorrect. There was a stage when Oracle was recommending only
> > using PUBLIC (not private as you stated) rollback segments with OPS, but I believe
> > that most people now prefer private ones in any situation for the added
> > manageability they offer.
> >
> > HTH.
> >
> > Pete
> >
> > "John P. Higgins" wrote:
> >
> > > The only time you would use private rollback segments is with OPS (Oracle
> > > Parallel Server). With OPS, you would have a database shared by several
> > > instances.
> > >
> > > Van Messner wrote:
> > >
> > > > I was looking at the rollback segments in several databases on separate
> > > > servers today. The segments are public even though each database is mounted
> > > > to a single instance. Are there any implications to be concerned about
> > > > here? Or does it really not matter in these circumstances?
> > > >
> > > > Thanks,
> > > >
> > > > Van
> >
> > --
> >
> > Regards
> >
> > Pete
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Peter Sharman Email: psharman_at_us.oracle.com
> > WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> > Worldwide Internal Services Education (650)607 0109 (local)
> > San Francisco
> >
> > "Controlling application developers is like herding cats."
> > Kevin Loney, ORACLE DBA Handbook
> > "Oh no it's not! It's much harder than that!"
> > Bruce Pihlamae, long term ORACLE DBA
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--

Regards

Pete

---

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Wed Feb 17 1999 - 12:17:03 CST