aio timed out n times" after issuing the command "Alter database add supplemental log data ;

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: aio timed out n times" after issuing the command "Alter database add supplemental log data ;

Symptoms:

The alert log issues a recurring message "aio timed out n times" after issuing the command "Alter database add supplemental log data ;"

Solution:

Aiowait timeouts mean that the request for an asynchronous I/O timed out - the timeout is 10 minutes which should be more than enough. The problem is generally load related but can often be resolved by tuning.

Please double-check with Solaris support that you have all async I/O patches applied.

Work around1:

As a temporary solution you can turn off disk_async_io by setting the parameter to false, and simulataneously increase the number of db_writer_processes to 4

Work around2:

After we have bounced the database these messages do not appear with no additional changes

References:

Note 222989.1 'Warning "aiowait timed out x times" in alert.log'

Internal Note 1005839.1 'Oracle AIO issues with ORA-27062 failures or AIOWAIT messages'

Get Oracle Certifications for all Exams
Free Online Exams.com