Re: Rollback segments offline on database restart

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Tue, 11 Jul 2000 16:14:15 +0200
Message-Id: <10555.111659@fatcity.com>

Hi

This should be specified in your initSID.ora. there is a parameter called rollback_segments =3D (r01, r02, r03, r04, = r05, r06, ....)
You should list the rollback segments in the initSID.ora file. it will automatically startup

regards
$uhen

>>> lravibabu_at_hotmail.com 07/11/00 03:44PM >>>
Hello,
I have created 25 rollback segments. Now whenever i restart the database = few=20
rollback segments are offline. To one procedure i have assigened one=20 rollback segment with the help of 'set transaction use ....'. Now = whenever=20
the database is restarted around 5-7 rollback segments are offline, which = i=20
manually have to set it online again. How to get this thing done. Do i = have=20
to use rollback_segments parameter and list out all(more than 25) = segments=20
there?
Please help.
Ravi.

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com=20=

--=20
Author: Ravi Babu
  INET: lravibabu_at_hotmail.com=20

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). Received on Tue Jul 11 2000 - 09:14:15 CDT