UPDATE Statement Struck on Wait Event "Disk File Operations I/O"
(Doc ID 2326578.1)
Last updated on NOVEMBER 07, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
- UPDATE statement struck 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