| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback segments offline on database restart
You need to include them in the init.ora:
rollback_segments = (...,....)
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: "Ravi Babu" <lravibabu_at_HOTMAIL.COM>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 7/11/00 1:44:42 PM
>
>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).
>
>
 |
 |