Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: big batch & small transactions at same time?

Re: big batch & small transactions at same time?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/17
Message-ID: <963854629.22342.2.pluto.d4ee154e@news.demon.nl>#1/1

"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!

I would suggest -I know it works!- Oracle Parallel Server for such purpose. One instance is configured for OLTP access and one instance is configured for batch access. Works quite well, regardless of platform and version :)

Regards,

Sybrand Bakker, Oracle DBA
Couldn't just resist at least mentioning the issue :) Received on Mon Jul 17 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US