Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: VXFS an create datafile

Re: VXFS an create datafile

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 17 May 2005 14:53:46 GMT
Message-ID: <428a056c.344288015@localhost>


truss the oracle process instead, and see what happens.

On 17 May 2005 02:01:07 -0700, ylecornec_at_hotmail.com wrote:

>
>Sybrand Bakker a =E9crit :
>> On 13 May 2005 02:58:05 -0700, ylecornec_at_hotmail.com wrote:
>>
>> >discovered_direct_io seems to have a very strange behavior...has
>> >someone already noticed this behaviour, and understand what happens?
>>
>> Standard Vxfs doesn't support async IO. If you have async_io enabled
>> in the database, Oracle will issue KAIO calls. They will fail and
>> Oracle will automatically fall back into issuing an ordinary pwrite.
>> This is the behavior you are observing.
>> You need to find a bunch of $$ and buy Veritas Database Edition to
>> resolve this, or disable async io.
>>
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
>Thank you,
>but my question is about the double write: why do we have the IO
>written 2 times??? I've set disk_asynch_io to false: its the same
>behavior as with the parameter set to true.
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Tue May 17 2005 - 09:53:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US