any procedure pooling?

[Quoted] 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 [Quoted] (say user2) call and run the same procedure. is there any procedure locking or pooling handled by ORACLE internally? [Quoted] or it works fine? which means while user1 is running the procedure, user2 [Quoted] can also invoke the procedure and run it, it doens't affect anything, or [Quoted] perharps the things it affects is the internal source of the procedure (if [Quoted] got update or insert or select statement) that will cause data inconsitenscy [Quoted] problem. (which is similar to cases whereby different user login as different session and issue same update statement, some locking mechanism [Quoted] will occur in ORACLE).

do i guess correctly?

pls help me to solve this doubt. your help would be greatly appreciated. [Quoted] thanks alot.

regards,
lkw Received on Mon Feb 12 2001 - 09:32:46 CET