My Oracle Support Banner

Update Query Hanging and Waiting for 'transaction' (Doc ID 2586090.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Below are the details from 10046 trace:

WAIT #9: nam='transaction' ela= 1000039 undo seg#|slot#=67371041 wrap#=3244 count=3686 obj#=77119 tim=8322546898437

WAIT #9: nam='DFS lock handle' ela= 642 type|mode=1413545989 id1=3 id2=1028 obj#=77119 tim=8322546899468

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution


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