Re: vxfs 5.1sp1 solaris 10u9 qio not makes asynch read oracle 11.2.0.2

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 22 Mar 2012 18:59:54 +0700
Message-ID: <CABcgmSHgC9Voc1pP7Ebd0aDmqfWf2jPNJivHKDff6CXnoroC4Q_at_mail.gmail.com>



hi Phil,

thanks for the url...
I have read those url 3 times before this trussing :)

do you think that statement comes from oracle kernel guy? or
because of open flag for O_DSYNC

28355: open("/data01/zzztest1.dbf", O_RDWR|O_NDELAY|O_DSYNC|O_NONBLOCK) = 10

that's why asynch io didn't work?

On 3/22/12, Phillip Jones <phil_at_phillip.im> wrote:
> Hi,
>
> You may find this archive post/thread of interest:
> http://www.freelists.org/post/oracle-l/Async-and-Direct-IO-On-Solaris-using-VXFS,5
>
> Cheers,
>
> Phil
>
> On Thu, Mar 22, 2012 at 6:04 AM, Ujang Jaenudin
> <ujang.jaenudin_at_gmail.com>wrote:
>
>> dear all,
>> I have a puzzle things for this environment.
>>
>> I tested create table as select/CTAS (the original table is on QIO file)
>> it looks no kaio AIOREAD, but uses pread (synchronous IO).
>>
>> play with db parameter:
>> filesystemio_options
>> disk_asynch_io
>>
>> has no effects.
>>
>> anyone had same experiences?
>> do you think oracle has some issues on this veritas QIO to use kaio
>> AIOREAD
>> <http://www.freelists.org/webpage/oracle-l>
>>
>>
>>
>

-- 
regards,

ujang jaenudin
databases independent consultant
http://ora62.wordpress.com
jakarta - Indonesia
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 22 2012 - 06:59:54 CDT

Original text of this message