UPDATE Statement Stuck on Wait Event "Disk File Operations I/O" (Doc ID 2326578.1)

Last updated on MARCH 04, 2021

Applies to:

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

UPDATE statement stuck on wait event "Disk file operations I/O" with P1=8, P2=0 and P3=8.
With reference to internal Doc ID 1397241.1, P1=8 means "wait for miscellaneous io (ftp, block dump, password file)" and P3=8 means "any other type".
Auditing has been enabled at DB level with XML,EXTENDED
I/O subsystem performance is well within the recommended limits (i.e.) Average read (ms).

Object level auditing for the referenced table was enabled:

	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.