Re: any procedure pooling?

In article <96876l$ntq$1_at_violet.singnet.com.sg>,   "lkw" <lkw_at_axiomatique.com> wrote:
> hi all,
>
> here is a question puzzled me.
>
> say if i got one procedure who will take 5 minutes to run and finish.
>
> if user1 one call the procedure and run it, after 1 minute then
 another user
> (say user2) call and run the same procedure.
> is there any procedure locking or pooling handled by ORACLE
 internally?
> or it works fine? which means while user1 is running the procedure,
 user2
> can also invoke the procedure and run it, it doens't affect anything,
 or
> perharps the things it affects is the internal source of the
 procedure (if
> got update or insert or select statement) that will cause data
 inconsitenscy
> problem. (which is similar to cases whereby different user login as
> different session and issue same update statement, some locking
 mechanism
> will occur in ORACLE).
>
> do i guess correctly?
>
> pls help me to solve this doubt. your help would be greatly
 appreciated.
> thanks alot.
>
> regards,
> lkw
>
>

As with *all* software, every process runs a new instance of your procedure. So there is no problem at all, and it is up to your procedure to take care of proper table or row locking.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/