Re: Separate Rollback Segment for batch...

You can create a second instance with the big private rollback segments and start this instance at night to batch processing. It would be better to made the rollback segments in first instance private too, or even better ( but boring) explisity show rollback segment in all transactions for batch processing instance. Hope it help you.

Sergei Agalakov

NetComrade wrote:
>
> 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 - 13:20:20 CST