You can use the Locks window only if you are working with a block storage database.
In the window, you can unlock data locks, move columns (by dragging them to other locations), and resize columns (by dragging the boundaries of their column headings). However, you cannot unlock objects. To unlock objects, you use the Locked Objects window.
The Locks window displays the following columns, which display the following information:
User—All users who hold a lock on at least one data block
Application/Database—The applications and databases to which users are connected
Number of Blocks Locked—The number of blocks locked by each user
Lock Duration (Sec)—The amount of time, in hours:minutes:seconds, rounded to the nearest 10–second increment, that users have had their data blocks locked (The maximum amount of time that a user can lock a data block is set in the Application Properties window.)
When you click the Unlock button, you not only remove the selected user's lock but you also disconnect the user from the current session.
listlocks (ESSCMD) in the Oracle Essbase Technical Reference
removelocks (ESSCMD) in the Oracle Essbase Technical Reference