From: Reidy, Ron (Ron.Reidy_at_arraybiopharma.com)
Date: Mon Sep 29 2003 - 21:04:59 CEST
Date: Mon, 29 Sep 2003 13:04:59 -0600 Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B1F7F2E@fiji.arraybp.com> From: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com> Subject: RE: [suse-oracle] enabling async IO
Async IO is not turned on by default (I manually set 'disk_async_io = true' in init.ora after the relink.
From metalink:
cat /proc/slabinfo |grep kio
for E.g
output with async io enabled.
> cat /proc/slabinfo |grep kio
kioctx 270 270 128 9 9 1 : 252 126
kiocb 66080 66080 96 1652 1652 1 : 252 126
kiobuf 236 236 64 4 4 1 : 252 126
oracle@rockjaw:/data2/oast/home>
output with async io disabled
> cat /proc/slabinfo |grep kio
kioctx 0 0 128 0 0 1 : 252 126
kiocb 0 0 96 0 0 1 : 252 126
kiobuf 0 0 64 0 0 1 : 252 126
.
There are 3 caches involved.
The kioctx and kiocb are Async I/O data structures that are defined in aio.h. If it shows a non zero value that means async io is enabled.
If you have the source code loaded, you can review it at:aio.h
These data structures are using to track the I/O requests, and are allocated as part of the __init aio_setup() call in aio.c.
Note: I did not verify the above before turning on async io in the instance.
-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.
303.386.1480
-----Original Message-----
From: Eric Raskin [mailto:eraskin@paslists.com]
Sent: Monday, September 29, 2003 12:51 PM
To: Reidy, Ron; SuSE-oracle@suse.com
Subject: RE: [suse-oracle] enabling async IO
Thanks.
Just out of curiosity, how do you know that Async I/O is now turned on and
that it was turned off before? Where can you view the settings/effects?
TIA
Eric Raskin
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
Sent: Monday, September 29, 2003 2:47 PM
To: eraskin@paslists.com; zhu chao; SuSE-oracle@suse.com
Subject: RE: [suse-oracle] enabling async IO
I am using 9.2.0.4.0.
'async_on' may not be a target, but following the directions from Zhu, all
worked for me.
Please see http://www.suse.com/oracle/ before posting
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
-- To unsubscribe, email: suse-oracle-unsubscribe@suse.com For additional commands, email: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.7 : Mon Sep 29 2003 - 21:05:21 CEST