My Oracle Support Banner

Workspace Manager Lock Issue (Doc ID 2402059.1)

Last updated on JUNE 04, 2018

Applies to:

Workspace Manager - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

On a 12.1.0.2 database, after executing 'exec DBMS_WM.SetLockingON('E');', the software aborted and it left the session locked. And now, since the session is no longer accessible there is no way to set the lock off in the same session where it was set on.

Running the 'EXECUTE DBMS_WM.SetLockingOFF;' procedure in a separate session does not unlock the locked session.

connected as MAF
SQL> select * from USER_WM_LOCKED_TABLES;
TABLE_OWNER TABLE_NAME LOCK_MODE LOCK_OWNER LOCKING_STATE
-------------------- -------------------- ------------------- -------------------- --------------------
MAF MSP EXCLUSIVE MAFDATA MAF_WS
MAF MDTP_2F9D1D1$ EXCLUSIVE MAFDATA MAF_WS

How do we unlock these locked tables?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.