Asynchronous I/O for Oracle9iR2(9.2.0.4) on Linux 2.6.8
|
|
First: Download aio-stress.c from [1] and compile gcc -Wall -laio -lpthread -o aio-stress aio-stress.c Run aio-stress tests and make sure kernel does support AIO
|
|
Second:
Build "libaio-oracle" as root
Download libaio-oracle-0.3.0.tar.gz:
Source to libaio-oracle version 0.3.0
from
http://oss.oracle.com/projects/libaio-oracle/files
cd /tmp
gunzip libaio-oracle-0.3.0.tar.gz
tar xf libaio-oracle-0.3.0.tar
cd libaio-oracle-0.3.0
./configure
make install
Add to /etc/ld.so.conf
/lib
/usr/lib
/usr/local/lib
Restart Linux.
Run control test: lio_test.
Next:
su - oracle
Shutdown oracle
mv $ORACLE_HOME/rdbms/lib/skgaio.o $ORACLE_HOME/rdbms/lib/skgaio.orig
cp /tmp/libaio-oracle-0.3.0/libaio-oracle.o $ORACLE_HOME/rdbms/lib/skgaio.o
$make -f ins_rdbms.mk async_on
$make -f ins_rdbms.mk ioracle
Startup Oracle
Modify screen SPFILE of OEM concole
disk_asynch_io=true
filesystemio_options=asynch
Click "Apply"
Restart instance
Actually file skgaio.o taking part in linking Oracle binaries,
$make -f ins_rdbms.mk async_on
$make -f ins_rdbms.mk ioracle
is now replaced by /tmp/libaio-oracle-0.3.0/libaio-oracle.o
References
1.http://ftp.belnet.be/linux/SuSe/people/mason/utils
|
This topic does not have any threads posted yet!
You cannot post until you login.
