How the Locking Level is Determined
The lock level selected for a table is determined in the following order of precedence:
• SET LOCKMODE ON table_name WHERE LEVEL = lock_level
• SET LOCKMODE SESSION WHERE LEVEL = lock_level
• The configured system_lock_level