Explicit Locks

Explicit locks are created with LOCK TABLE or SELECT ... FOR UPDATE statements. If a session is blocked because of a LOCK TABLE, you will see it associated with a enq: TM - contention wait event. If a session is blocked because of a SELECT ... FOR UPDATE statement, you will see it associated with a enq: TX - row lock contention wait event. You can find these statements in SQL text of running sessions.