Re: What's going on?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 25 Nov 2002 00:02:20 +0100
Message-ID: <uu2mlka0qbud93@corp.supernews.com>

"Tim C" <NOTCornwell_at_NOTcs.NOTcornell.NOTedu> wrote in message news:arrcu4$fmn$1_at_news01.cit.cornell.edu...
> Thanks in advance to anyone who can shed some light on this, or tell me
> where to look for some help.
>
> I start two processes - P1 and P2. Both should take about X minutes when
run
> alone.
> Process P1 finishes in X+Y minutes - not surprising because there were two
> running.
> However:
> Process P2 is still running after 2X+Y (actually *much* longer) minutes.
> More facts:
> Both of these processes update the same table - but different records.
There
> are many Update statements in both processes.
> Help!
> Tim
> Oracle 9.2.0...
> Red Hat Advanced Server 2.5
> Intel (Dell) 2-processor (Xeon)
>
>

Someone have his/hers crystall ball ready? No clues at all in this post other than 'it doesn't work as expected'!

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sun Nov 24 2002 - 17:02:20 CST