Re:Monitoring execution of Packages

From: <dgoulet_at_vicr.com>
Date: Fri, 30 Jun 2000 09:20:26 -0400
Message-Id: <10544.110905@fatcity.com>

Marc,

Take a look at the dbms_lock package, it's made to purpose. I use it= for a
similar application and it works like a charm.

Dick Goulet

____________________Reply Separator____________________

Subject: Monitoring execution of Packages Author: "Blum; Marc" <blum_at_soptim.de>
Date: 6/29/00 11:36 PM

Hi all,

is there any possibility to determine, =

if a package is already in execution by another user?

Our requierements are, that a specific very resource =

intensive job is only executed once at a time. If another =

user starts the job, the package should see, that it is =

already being executed ba another user and should =

return an error to the user. =

Further, it would be great to see from outside, if the =

execution hangs, so some admin could kill it.

Our ideas are:

the package locks a row in a table
the package puts messages in a pipe, so another =

process can read them

Is there any dynamic performance view, wich =

supports our requierements?

Any ideas or suggestions?

Thanx very much
Marc

Marc Blum
SOPTIM GmbH
Gr=FCner Weg 22-24
D-52070 Aachen -Germany-
Phone: +49-(0)241-91879-29
Fax: +49-(0)241-154038
EMail: BLUM_at_SOPTIM.DE

Author: Blum, Marc
INET: blum_at_soptim.de

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). Received on Fri Jun 30 2000 - 08:20:26 CDT