Wait Event – enq: TX – row lock contention

This wait event can occur for several reasons. If one user is wanting to update or delete a row or rows that another session is modifying. The session holding the lock will release it when it performs a COMMIT or ROLLBACK. If a session is waiting due to potential duplicates in a UNIQUE index. If…

Wait Event – DFS lock handle

The session waits for the lock handle of a global lock request. The lock handle identifies a global lock. With this lock handle, other operations can be performed on this global lock (to identify the global lock in future operations such as conversions or release). The global lock is maintained by the DLM.   Wait Time: The…

Adding & Removing Voting Disk

This is a quick article on managing Voting Disk, the voting disk internals are explained in Voting Disk Internals post. From 11g release 2, voting disks can be stored on either on ASM diskgroups or on cluster file systems, following are the steps to add/delete/move a voting disk:- How to add a Voting Disk When voting disk…