Deadloack

[irehman]

If I insert and Update on the same table at the same time, will it create a deadlock?

Thanks in Advance

[marist89]

http://metalink.oracle.com/metalink/...T&p_id=62365.1

[irehman]

Sorry, I don't have access to metalink. Any suggestion

[jovery]

If the Insert and update is within the same session then no, the premiss behind a deadlock is that sessionA requests an object which is locked by sessionB at the same time sessionB is attempting to use the object SessionA is locking.

Regards