Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this procedure running ?
You can check out V$SESSION on active sessions and programs. Of course you can simply change a status of a row in an additional table and change it back at the end of the procedure. Be carefull with faulting situations, always clear the status, preventing the procedure of not being able to run without a manual update of the table.
regards,
Guus van de Sande
Independent Oracle consultant
Luis Gregorio <Lgregorio_at_aliuap1.mailpac.pt> schreef in artikel
<6e3prn$gb0$1_at_duke.telepac.pt>...
> 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
>
>
>
Received on Tue Mar 10 1998 - 00:00:00 CST