Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Separate Rollback Segment for batch...
Hope it helps,
Eugene.
NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
news:38a2cfe5.148759992_at_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 - 10:07:34 CST