Disk File Operations I/O

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

Symptoms

• 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).

 

Changes

Object level auditing for the referenced table was enabled:

audit alter,insert,update,delete on <table_name> by <USERNAME>;

 

Cause

Enabled object level auditing.

Solution

Disable object level auditing for the referenced object:

NOAUDIT INSERT TABLE, UPDATE TABLE, DELETE TABLE BY <USERNAME>;