| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> big batch & small transactions at same time?
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).
 |
 |