New answers tagged locking
You can explicitly specify using : SET LOCK_TIMEOUT timeout_period timeout_period Is the number of milliseconds that will pass before Microsoft SQL Server returns a locking error. A value of -1 (default) indicates no time-out period (that is, wait forever). When a wait for a lock exceeds the time-out value, an error is returned. A value of 0 ...
No it isn't possible to set this as a default and change it from -1 (no timeout). If it needs to be changed, you have to be explicit with a call to SET LOCK_TIMEOUT <number of ms for timeout>. As for why there is no way to alter the default, we can only speculate. But my guess would be that the lack of a timeout would satisfy the majority of ...
You can get this info from DBA_LOCKS. select * from DBA_LOCKS where LOCK_TYPE = 'PL/SQL User Lock'; DBA_LOCKS has the SESSION_ID and the lock id.
Top 50 recent answers are included