Re: Public vs Private Rollback Segments

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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Wed Feb 17 1999 - 03:32:29 CST