Re: big batch & small transactions at same time?

I have about 40 small (1mb) rollback segments which are enabled for all (transaction-style) users.

Every so often, I have to move a large number of records. I use a large rollback, enabled just for this, to serve this purpose.

alter rollback segment waybig online;

set transaction used rollback segment waybig;

begin

    do some stuff;

    commit;

end;

alter rollback segment waybig offline;

"Jay M. Scheiner" <jxs_at_wolpoff_nospm_law.com> wrote in message news:39730165.460541338_at_news.erols.com...
> How practical is it to have a system running that would have hundreds
> of users doing OLTP (lots of small transactions) while at the same
> time (occasionally) doing big batch work with larger transactions? I
> am thinking of rollback segments here.
>
> Does it hurt the OLTP work much to have larger rollback segments? My
> understanding is that you could have 1 big rollback segment for batch
> work, but you can't have it JUST for those transactions. That is, if
> an RBS is online, anyone can use it.
>
> Comments?
> (I did not include platform or version because this is supposed to be
> a concepts question. I am currently on 8.15 on NT but this is not
> necessarily what we would run a hundreds of users system on. This is
> not an excuse to start an OS war).
>
> _______________
> Jay M. Scheiner
> Programmer/Analyst
> Wolpoff & Abramson, LLP
> remove _nospm_ from email address
> Opinions are my own only!
Received on Wed Jul 19 2000 - 00:00:00 CDT