Re: Async I/O with Oracle 7.1.3 or 7.1.6 on HP/UX

From: Coyne Gibson <coyne_at_convex.com>
Date: 1995/06/06
Message-ID: <3r23kl$8eb_at_yagaman.convex.com>#1/1


In <D9qEEz.74F_at_magi.com> Ian Abramson <sensfan_at_magi.com> writes:

>rp1399_at_email.sps.mot.com (Steve Lemme) wrote:
>>> I am trying to find someone who has set up Async I/O on an
>>> HP/UP v9.04 with either Oracle 7.1.3 or 7.1.6.
>>>
>>> We have been talking to Oracle "Support", and they have
>>> said that we should set the ANSYC_WRITE=true in the INIT.ORA. The
>>> only problem is that the parameters does NOT exist (7.1.3). We pointed this
>>> out, and "Support" has said that the parameters will be supported in
>>> 7.1.6. I then talked to a friend who does have 7.1.6 installed, and
>>> guess what....no parameter.
>>
>>
>>We use it. It is enabled as an HPUX Kernel parameter.
>>
>>
>>Steve Lemme
>>DBA
>>MOTOROLA
 
>Steve,
 

> What did you do in the OS, we have set-up raw devices and such, but
>how does Oracle know that it is using Async?
 

>Thanks,
 

>Ian
 

>>

The default for Oracle V7.1.3 is to use the async I/O facility in HP-UX *if* it is enabled in the HP-UX kernel, *and* if the I/O is directed at a raw disk partition. In later releases of Oracle, this becomes a configurable parameter vs. the current "default attempt to use" approach.

The net message: in 7.1.3 if you target a raw partition *and* async I/O is present in the kernel, it will be used.

Oracle also supports an "emulation" of async I/O support vis a vis use of multiple db writers, if your O/S lacks it (or its disabled in the kernel). The configurable parameter db_writers enables or disables the Oracle emulation of async I/O.

-- 
Coyne Gibson                          Systems Architect - Research & Development
Convex Computer Corporation                           Internet: coyne_at_convex.com
3000 Waterview Parkway			              FAX:   (214) 497-4441
Richardson, TX 75083                                  Voice: (214) 497-4842
Received on Tue Jun 06 1995 - 00:00:00 CEST

Original text of this message