1. Requires libaio packages. (RHEL 3 Update 2)
1. libaio-0.3.96-3.i386.rpm
2. libaio-devel-0.3.96-3.i386.rpm
2. By default async io is not enabled in oracle binary. Therefore you need to relink oracle as follows for async io. Also look at <Note:270213> & <Bug:3438751> .
*
make PL_ORALIBS=-laio -f ins_rdbms.mk async_on
3. In init.ora file add following option.
* for data files on raw devices
o disk_asynch_io=true (this is default option)
* for data files on file system
o filesystemio_options =asynch
o disk_asynch_io=true (this is default option)
Partager