UPDATE Statement Struck on Wait Event "Disk File Operations I/O"
Last updated on NOVEMBER 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms