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"
Received on Tue Jul 11 2000 - 11:14:45 CDT
