Pages

Tuesday, April 23, 2019

Acquire with NOWAIT error and TRUNCATE command


A good example - https://community.oracle.com/thread/634676

Oracle parameter: select * from v$parameter where name = 'ddl_lock_timeout'  (in sec)

Note: truncate is a DDL

Ex: 
select dummy from t where dummy='X' for update nowait;
select dummy from t where dummy='X' for update wait 5;