Is Async IO being Used or NOT ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 5 Nov 2008 13:05:38 +0530
Message-ID: <69E1360E54B50C4A828A136C158E47420554B3FB80@BLRKECMBX02.ad.infosys.com>

Folks

Need to find out if Async IO is setup & working or NOT in our Performance Benchmark Setup.

Qs 1 - What HP-UX Command gives the existing filesystemio_options settings for the mounted filesystem ? NOTE - Init.ora parameter disk_async_io=true (default)

Qs 2 - For Async IO to work, is there a dependency or NOT on the existence of the file "/dev/async" ? ... This file does NOT exist Currently ... Is the presence of this file merely to suppress the below Error Message in Oracle Trace files.

Oracle Trace Files currently contain the Message:- Error - File '/dev/async' not present : errno=2

Related Link - http://sap.ittoolbox.com/groups/technical-functional/sap-basis/ecc-upgrade-phase-tabimupg-error-1790565

Existing Configuration:-
Oracle 10.2.0.1
System name: HP-UX

Node name:      SPEHPPA1
Release:        B.11.11
Version:        U
Machine:        9000/800

Instance name: LOSDB
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 21553, image: oracle_at_SPEHPPA1

Will provide any info needed .... Cheers & Thanks V much

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 05 2008 - 01:35:38 CST