Separate Rollback Segment for batch...

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 10 Feb 2000 14:48:58 GMT
Message-ID: <38a2cfe5.148759992@news.earthlink.net>

We have a db, where we have batch processes running at night, and very small transactions during the day, since I figure the batch jobs would want bigger extents in rbs, etc. So I created a new tablespace and one big rbs in it, but I noticed it immediately was being used.

So I need a way to figure out how to use it only for my transaction(s) at night. I figured to give the batch user the ALTER ROLLBACK SEGMENT privilage and let him put it online, set transaction to use it and then put it offline, but that creates a problem of other transactions still accessing it, or is it a problem?

Thanx.

---

In case I forgot to mention:
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Thu Feb 10 2000 - 08:48:58 CST