Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback Segnments: Public or Private?
See comments indented.
"Kevin P. Fleming" wrote:
> 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...
Not so since version 6 days. Then you couldn't add them dynamically. Version 7 up allows you to create a private rollback segment then alter it to online without necessarily modifying the init.ora parameter. Of course, if you shutdown and restart without editing the init.ora file, only the private ones listed in the rollback_segments parameter will be started.
>
> 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.
Wrong. Again in version 6 OPS had public ones recommended. Now, private ones are recommended for both OPS and non-OPS environments.
>
>
> Bill Fee wrote in message <7bjptp$fqc9_at_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
> >
> >
> >
> >
--
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