Automatic RollBackSegments Online

From: Joost Schoonderbeek <j.schoonderbeek_at_HumanInference.com>
Date: Mon, 13 Sep 1999 08:27:52 GMT
Message-ID: <04932F2B7E20D211856C00A0C9A0609508E51F@HIS03>

Just add to the parameterfile initorcl.ora (...\orant\database\initorcl.ora) the following line.

ROLLBACK_SEGMENTS =
(rb1,rb2,rb3,rb4,rb5,rb6,rb7,rb8,rb9,RBS_S1,RBS_S2,RBS_M1,RBS_M2,RBS_L1, RBS_L2,RBS_XL) Just make sure you add the correct RBS-names to the list.

Greetings
Joost Schoonderbeek

> -----Original Message-----
> From: ccetks_at_leonis.nus.edu.sg (Tan Keok San)
> [SMTP:ccetks_at_leonis.nus.edu.sg]
> Posted At: Monday, September 13, 1999 5:26 AM
> Posted To: misc
> Conversation: Starting Oracle in NT
> Subject: Starting Oracle in NT
>
> I've got a script that alters the rollback segments in my NT-based
> Oracle
> database. Oracle starts up when NT is rebooted. However where should
> I
> place the script to alter the segments so that NT starts up with the
> segments altered after rebooting?
>
> Thanx in advance.
Received on Mon Sep 13 1999 - 03:27:52 CDT