any procedure locking or pooling simultaneous calling?

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 Received on Mon Feb 12 2001 - 02:33:22 CST