Re: Is Async IO being Used or NOT ?

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 6 Nov 2008 09:14:20 +0100
Message-ID: <6e9345580811060014v1987022ei65bb47013021ca04@mail.gmail.com>


AFIAK ODM comes with Veritas Cluster Filesystem or Veritas Database Edition (they probably changed product name). The package is called VRTSodm

But an easier way is simply check if $ORACLE_HOME/lib/libodm* is linked to some third party driver, from alert you can also see messages if odm is used such as

Cluster communication is configured to use the following interface(s) for this instance
  10.100.70.13
Thu Sep 11 14:39:29 2008
Oracle instance running with ODM: VERITAS 4.1 ODM Library, Version 1.0 cluster interconnect IPC version:Oracle UDP/IP (generic) IPC Vendor 1 proto 2

There is another way, if odm is mounted you can see /dve/odm device

There is another way, tusc the oracle process and look for odm_io() sys calls

You can also check if file system is mounted with qio option, simply run mount as root it will show you

Regards

--
LSC


On Thu, Nov 6, 2008 at 8:33 AM, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>wrote:


> Some basic Qs on ODM LSC, Folks below
>
>
>
> 1. How is it possible to check if ODM(Oracle Disk Manager) is setup or
> NOT on the machine?
> 2. Does ODM need a Separate Setup on HP-VXFS? .. Is it separated
> Licensed? If so by who - Oracle Corp or HP?
>
>
>
> Am assuming that HP-UX uses VXFS by Default.
>
>
>
> Cheers & Thanks V much
>
>
> ------------------------------
>
> *From:* LS Cheng [mailto:exriscer_at_gmail.com]
>
> aio is only posible with raw devices in hp-ux unless you use odm on vxfs
>
> Thanks
>
> --
> LSC
>
> On Wed, Nov 5, 2008 at 8:35 AM, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
> wrote:
>
> 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
>
> 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 Thu Nov 06 2008 - 02:14:20 CST

Original text of this message