Re: Rollback Segnments: Public or Private?

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_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
>
>
>
>
Received on Wed Mar 03 1999 - 14:06:35 CST