Re: Rollback Segnments: Public or Private?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 03 Mar 1999 11:50:14 -0800
Message-ID: <36DD9276.8B934B37@us.oracle.com>

Bill

Private ones are easier to manage. Most people use private ones as listed in the init.ora file, rather than having to find some way to bring them online in response to greater user demand etc. Public RBS are now also not required or recommended for OPS.

HTH Pete

Bill Fee wrote:

> 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

Received on Wed Mar 03 1999 - 13:50:14 CST