RE: Rollback segments offline on database restart

One more advantage to option 1 is that if you decide you want to bring up your database without those rollback segments, it's a lot simpler to bounce the database and use a different init.ora which excludes them, than it is to offline each of them

>From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Rollback segments offline on database restart
>Date: Tue, 11 Jul 2000 09:25:33 -0800
>
>Mariana,
>
>One should probably always choose option #1 , as #2 is dependent
>on the ratio : (transactions/transactions_per_rollback_segment).
>What this means, is that if the value of transations=100 and
>transactions_per_rollback_segment=4, then the total number of
>rollback segments (public and private) that Oracle will bring
>online on startup, will not exceed 25.
>
>So, rather than going and fiddling with those 2 parameters to
>make things work, it should be preferred to just create all
>rollback segments as "private" and put their names in the list
>of values in the rollback_segments parameter. It must also be
>noted here that the number of "actual transactions per rollback
>segment" has nothing to do with the
>transactions_per_rollback_segment parameter. The number of
>actual transactions per rollback segment is O-S and
>db_block_size dependent.
>
>Best Regards,
>
>Gaja.
>
>--- "Galleri, Mariana" <MGalleri_at_uniFON.com.ar> wrote:
> >
> > Ravi,
> >
> > You have two options.
> >
> > 1- You have to use rollback_segments parameter and list out
> > all(more than
> > 25) segments
> > there, or
> > 2- You can create public rollback segments and you don't need
> > to use
> > rollback_segments parameter
> >
> > Regards.
> >
> >
> > -----Mensaje original-----
> > De: Ravi Babu [mailto:lravibabu_at_hotmail.com]
> > Enviado el: Martes 11 de Julio de 2000 10:45
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Rollback segments offline on database restart
> >
> >
> > Hello,
> > I have created 25 rollback segments. Now whenever i restart
> > the database few
> >
> > rollback segments are offline. To one procedure i have
> > assigened one
> > rollback segment with the help of 'set transaction use ....'.
> > Now whenever
> > the database is restarted around 5-7 rollback segments are
> > offline, which i
> > manually have to set it online again. How to get this thing
> > done. Do i have
> > to use rollback_segments parameter and list out all(more than
> > 25) segments
> > there?
> > Please help.
> > Ravi.
> >
> >
>________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> >
> > --
> > Author: Ravi Babu
> > INET: lravibabu_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> >
>--------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> > You may
> > also send the HELP command for other information (like
> > subscribing).
> > --
> > Author: Galleri, Mariana
> > INET: MGalleri_at_uniFON.com.ar
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> >
>--------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> > You may
> > also send the HELP command for other information (like
>subscribing).
>
>
>=====
>Gaja Krishna Vaidyanatha
>Director, I-O Management Products
>Quest Software Inc.
>(972)-304-1170
>gajav_at_yahoo.com
>
>"Opinions and views expressed are my own and not of Quest"
>
>__________________________________________________
>Do You Yahoo!?
>Get Yahoo! Mail – Free email you can access from anywhere!
>http://mail.yahoo.com/
>--
>Author: Gaja Krishna Vaidyanatha
> INET: gajav_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).