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

Last updated on JULY 20, 2024

Applies to:

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

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

	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

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