The OS administrator in your company informed you about the upgrade of storage to new disk controllers and hard disks. You want to test if the new I/O devices are capable of handling the I/O load. The database is using Automatic Storage Management(ASM) for storage. To test the throughput and other I/O metrics, you performed IO calibration from the Enterprise Manager but you notice that the IO calibration job failed. To see the details of the error, view the Exhibit.
How you can resolve the error?
A.
Set FILESYSTEMIO_OPTIONS to NONE and DISK_ASYNCH_IO to FALSE.
B.
Set FILESYSTEMIO_OPTIONS to SYNCH and DISK_ASYNCH_IO to FALSE.
C.
Set FILESYSTEMIO_OPTIONS to ASYNCH and DISK_ASYNCH_IO to TRUE.
D.
Set FILESYSTEMIO_OPTIONS to DIRECTIO and DISK_ASYNCH_IO
Given answer of C is obviously correct.
Explanation:
http://arup.blogspot.co.uk/2008/08/resource-manager-io-calibration-in-11g.html
ERROR at line 1:ORA-56708: Could not find any datafiles with asynchronous i/o capability
To enable asynch I/O, set two values in the init.ora file (or spfile) and recycle the instances:
disk_asynch_io = true
filesystemio_options = asynch
The first one is default; so you may not have to change it. The default of the second one is NONE; so you will probably have to change it. After setting these values and recycling the instance, confirm at the file level:
select name,asynch_io from v$datafile f,v$iostat_file i
where f.file#=i.file_no
and (filetype_name=’Data File’ or filetype_name=’Temp File’)