Using the LOCK TABLE Statement with the WAIT Option: Example
{"Image DocumentName": "Using the LOCK TABLE Statement with the WAIT Option: Example", "Image ImageDescription": "In session #1: Time. In session #2: LOCK TABLE orders. IN EXCLUSIVE MODE; LOCK TABLE orders. IN EXCLUSIVE MODE. WAIT 60; ORA-00054: resource busy. and acquire with NOWAIT. specified or timeout. expired. LOCK TABLE \u2026 WAIT: Example. In the example shown in the slide, the ORDERS table is locked in session 1. In session 2, a user tries to put a lock on the same ORDERS table, but specifies to wait 60 seconds. This means that if the table is already locked by another user, session 2 will wait 60 seconds for the lock. If the lock in the other session is not released after 60 seconds, an appropriate error message is returned to the session 2 user. Oracle Database 11g: SQL and PL/SQL New Features", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}