1.

What Is No-wait?

Answer»

When one procedure is accessing a table in EXCLUSIVE LOCK mode at the same time some other procedure TRY to access the same table it will not wait till the table is released if the no-wait option is used.

When one procedure is accessing a table in exclusive lock mode at the same time some other procedure try to access the same table it will not wait till the table is released if the no-wait option is used.



Discussion

No Comment Found