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: Is this procedure running ?

Re: Is this procedure running ?

From: Dr. Jan Dieckmann <jdieckmann_at_psi.de>
Date: 1998/03/11
Message-ID: <3506C2AF.7F44@psi.de>#1/1

Luis Gregorio wrote:
>
> My question is: Is there anyway of knowing if a certain procedure is already
> running?
>
> I want to create a procedure to do a specific job everytime it is called,
> but if when it's called it's already running I dont want to execute the
> procedure again.
>
> Does existe any view or table where I can find this information? Or do I
> have to build same kind of algorithm to go around the problem ?
>
> Every sugestion is welcome.
>
> Thanks in advance:
> Luis Gregorio

Our tool Hora 3(free trial version of Hora 3: www.keeptool.com)shows on the session page what is stored about all session and on the jobs page what is stored about all jobs.

Jan Dieckmann
jan.dieckmann_at_keeptool.com
KeepTool GbR Received on Wed Mar 11 1998 - 00:00:00 CST

Original text of this message

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