Range of the SET LOCKMODE Statement

Database Administrator Guide > Database Administrator Guide > Understanding the Locking System > User-Controlled Locking--SET LOCKMODE > Range of the SET LOCKMODE Statement

Was this helpful?

With the SET LOCKMODE statement, you can:

• Set locking parameters for a particular table. For example:

set lockmode on emp where readlock = nolock;

• Set locking parameters for the duration of a session. For example:

set lockmode session where readlock = nolock;

If multiple SET LOCKMODE statements are issued for the same session or table, the most recent statement is the one in effect. Setting a locking parameter on a specific table has precedence over the session setting. Any lockmode settings issued during a session end when that session ends.

Last modified date: 11/28/2023