Re: 2 batch jobs kill performance

Hotsos.com is run by my dear friend Cary Millsap (author of the original OFA standard, former VP of Oracle's System Performance Group, etc., etc.) and one of the articles available there to subscribers is his excellent 9-page story about why you should have a maximum of two batchjobs concurrently executing on the same CPU.

I used to run a group called Premium Services out of Oracle Denmark, and when I told them (we were about 40 pretty experienced guys) about this stuff, we had a lot of shouting, fist fighting and throwing of beer bottles before they finally had to accept the hard fact about batch jobs.

The real fun begins when you realize just what a batch job is. It's a job that logs in, runs un-attended for a while, then logs out. It's not just the jobs sitting in OS queues. Think about parallel query jobs, replication jobs, other dbms_job jobs, archiving processes, etc., etc. Or think about how users on most ERP-systems can start a report by hitting F5 or similar. There are suddenly many batch jobs out there :).

At one customer site we (Premium Services) mapped number of jobs that had run concurrently in the Oracle Apps Concurrent Manager queues (got the data from the CM tables) over time - then we went back to the customer and asked: "Was performance bad last Tuesday at 2 pm?" and they would say "Yeah!". Introducing simple batch discipline helped throughput in general and response time for interactive users in particular.

One thing we'd like to understand better here at Miracle A/S is how to determine how many batch-like jobs or processes are currently executing against a database. If anybody has good ideas for that, I'd like to hear about it.

Best regards,

Mogens

Sam Roberts wrote:

> There is a site www.hotsos.com and a paper about why 2 batch jobs kill
> system performance. The paper is protected so is there anybody on the list
> who can explain this, Im very curious
>
> thanks
>
> Sam
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, June 03, 2001 6:15 AM
>
> > Jared Still wrote:
> > >
> > > Same old FUD. Try to associate your competition with
> > > a scary word and make them a pariah.
> > >
> > > McCarthyism in the 50's, Balmerism in the 00's.
> > >
> > > Jared
> > >
> > > On Friday 01 June 2001 14:17, Jamadagni, Rajendra wrote:
> > > > Read the story here
> > > > (<url>http://www.suntimes.com/output/tech/cst-fin-micro01.html</url>)
> and
> > > > have a good laugh.
> > > >
> > > > LOL! TGIF
> > > > Raj
> >
> > This is not an email that I would normally post to the list - but since
> > its the weekend - why not?
> >
> >
> > Jared,
> >
> > The GPL has been referred to as a "virus" previously, due to inclusion
> > of GPL code causing the entire piece of code (at the execution unit) to
> > be required to be released under the same license.
> >
> > I have a problem with this section of the article:
> >
> > <snip>
> > Q: Do you view Linux and the open-source movement as a threat to
> > Microsoft?
> >
> > A: Yeah. It's good competition. It will force us to be innovative. It
> > will force us to
> > justify the prices and value that we deliver. And that's only healthy.
> > The only thing
> > we have a problem with is when the government funds open-source work.
> > Government funding should be for work that is available to everybody.
> > Open source
> > is not available to commercial companies. The way the license is
> > written, if you use
> > any open-source software, you have to make the rest of your software
> > open source.
> > If the government wants to put something in the public domain, it
> > should. Linux is not
> > in the public domain. Linux is a cancer that attaches itself in an
> > intellectual property
> > sense to everything it touches. That's the way that the license works.
> > <snip>
> >
> > "Open Source" != "GPL".
> > The GPL is one license - there are many like it, many unlike it.
> > http://www.fsf.org/philosophy/license-list.html#GPLCompatibleLicenses
> >
> > Here is an article by Stallman
> > http://www.cnn.com/TECH/computing/9911/08/freedom.GNU.idg/
> >
> > Linus Torvalds chose the GPL so that no one could "own" Linux.
> > There are other licenses that can be used for Free Software or Open
> > Source Software, such as the LGPL, Apache and BSD Artistic License. I've
> > heard rumors that much of the TCP/IP stack in Windows 2000 has its
> > origins in FreeBSD code - licensed under the BSD license.
> >
> > To Balmer - if Microsoft cannot "own" it - it is evil - and should not
> > be funded.
> > As not all Open Source work is licensed under the GPL, his statement is
> > overly broad and therefore false.
> >
> > Paul
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paul Drake
> > INET: paled_at_home.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sam Roberts
> INET: rabbit_at_emirates.net.ae
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: mno_at_MiracleAS.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).