| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: AIO in Ora9.2+redhatAS2.1?
Sorry for the incorrected sent mail.Now I resend it again.
Hi,Friends:
According to metalink note and otn paper:http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf, I relinked oracle and created a raw device for data tablespace, and later I created a table on it and did a full table scan, and in another terminal, I did a strace -p pid to look at its system call. However, It seems that it is not using aio at all, here is some of the tracefile, and another problem of that document, it says we should modify /proc/sys/fs/aio-max-size to 1M to make io more efficient, however, In my case, with the default 128K, OS is in fact doing 1M scan one time.
open("/dev/raw/raw1", O_RDWR|O_SYNC|O_LARGEFILE) = 11 (o_sync, doesn't it means sync io?) cntl64(0xb, 0x2, 0x1, 0x2) = 0 gettimeofday({1052298577, 939177}, {4294966816, 0}) = 0 gettimeofday({1052298577, 939204}, {4294966816, 0}) = 0 pread(11, "\20\2\0\0\t\0\0\3\276Zsu\0\0\v\4\33(\0\0\0\0\0\0\0\0\0"..., 8192, 73728) = 8192
gettimeofday({1052298577, 949382}, {4294966816, 0}) = 0
gettimeofday({1052298577, 949409}, {4294966816, 0}) = 0
gettimeofday({1052298577, 949434}, {4294966816, 0}) = 0
gettimeofday({1052298577, 949914}, {4294966816, 0}) = 0
gettimeofday({1052298577, 949941}, {4294966816, 0}) = 0
old_mmap(NULL, 1044480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x405d8000
pread(11, "\6\2\0\0\n\0\0\3\32Vsu\0\0\1\4\2\335\0\0\1\0\0\0\'\36\0"..., 1040384, 81920) = 1040384
gettimeofday({1052298577, 973701}, {4294966816, 0}) = 0
gettimeofday({1052298577, 973765}, {4294966816, 0}) = 0
gettimeofday({1052298577, 973796}, {4294966816, 0}) = 0
gettimeofday({1052298577, 977908}, {4294966816, 0}) = 0
gettimeofday({1052298577, 977951}, {4294966816, 0}) = 0
munmap(0x405d8000, 1044480) = 0
old_mmap(NULL, 1052672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x405d8000
pread(11, "\6\2\0\0\211\0\0\3\305Zsu\0\0\1\6\t\324\0\0\1\0\0\0\'\36"..., 1048576, 1122304) = 1048576
gettimeofday({1052298577, 993929}, {4294966816, 0}) = 0
gettimeofday({1052298577, 993994}, {4294966816, 0}) = 0
gettimeofday({1052298577, 994025}, {4294966816, 0}) = 0
gettimeofday({1052298577, 998212}, {4294966816, 0}) = 0
gettimeofday({1052298577, 998255}, {4294966816, 0}) = 0
pread(11, "\6\2\0\0\t\1\0\3\305Zsu\0\0\1\6\327\203\0\0\1\0\0\0\'\36"..., 1048576, 2170880) = 1048576
gettimeofday({1052298578, 13940}, {4294966816, 0}) = 0
gettimeofday({1052298578, 14003}, {4294966816, 0}) = 0
gettimeofday({1052298578, 14034}, {4294966816, 0}) = 0
gettimeofday({1052298578, 18402}, {4294966816, 0}) = 0
gettimeofday({1052298578, 18445}, {4294966816, 0}) = 0
Regards
zhu chao
msn:chao_ping_at_163.com
www.cnoug.org(China Oracle User Group)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: zhu chao
INET: chao_ping_at_vip.163.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 07 2003 - 07:02:54 CDT
 |
 |