Already tried
A reader, January 31, 2018 - 4:04 pm UTC
Hi,
Thank you for response.
I have already tried this but with no success.
the answer is instantaneous, and is not after 300 seconds of the timeout.
[SYS@XV2DEV12] SQL> alter session set ddl_lock_timeout = 300;
Session modifiée.
[SYS@XV2DEV12] SQL> alter table FALCON_DEV_06_USR.USR_TRANSACTION enable table lock;
alter table FALCON_DEV_06_USR.USR_TRANSACTION enable table lock
*
ERREUR à la ligne 1 :
ORA-00054: ressource occupée et acquisition avec NOWAIT ou temporisation indiqué
No session exist with this user and table is not locked :
[SYS@XV2DEV12] SQL> SELECT username FROM v$session
2 WHERE username = 'FALCON_DEV_06_USR';
aucune ligne sélectionnée
[SYS@XV2DEV12] SQL> select session_id, a.object_id, xidsqn, oracle_username, b.owner owner, b.object_name object_name, b.object_type object_type FROM v$locked_object a, dba_objects b WHERE b.object_id = a.object_id;
[SYS@XV2DEV12] SQL> select session_id, a.object_id, xidsqn, oracle_username, b.owner owner, b.object_name object_name, b.object_type object_type FROM v$locked_object a, dba_objects b WHERE b.object_id = a.object_id and OBJECT_NAME = 'USR_TRANSACTION' and ORACLE_USERNAME = 'FALCON_DEV_06_USR';
aucune ligne sélectionnée
February 01, 2018 - 12:59 am UTC
I think you'll need to log a call with Support.
I can't reproduce that on my 12.1 or 12.2 instance. Even the lock wait is a blocking wait, rather than a nowait one (and I have not set ddl_lock_timeout)
More info
A reader, February 01, 2018 - 6:21 am UTC
Provide the full table desc and related depensencies (jobs triggers etc)