- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 09:55 AM
тАО03-26-2003 09:55 AM
Anybody using DISK_ASYNC_IO in Oracle 8i?
http://bizforums.itrc.hp.com/cm/QuestionAnswer/0,,0xd26242308663d611abdb0090277a778c,00.html
Is this all you need to do to turn on Asynchronous IO in HP-UX? No kernel parameters?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 10:43 AM
тАО03-26-2003 10:43 AM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
Regards,
RZ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 11:03 AM
тАО03-26-2003 11:03 AM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
===============================================
From Metalink Doc ID: 59668.999
Thread Status: Closed
From: Christopher Duston 15-Feb-00 22:56
Subject: disk_async_io
RDBMS Version: V8.1.5
Operating System and Version: HP-UX 11.0
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): RDBMS
Product Version:
disk_async_io
8.1.5 on HP-UX 11.0 with file systems on EMC disk subsystem with memory cache on the controllers.
Do not have /dev/async. Have created multiple db writers. By default disk_async_io is true.
1) should I set disk_async_io to false?
2) Does the EMC subsystem allow me to take advantage of disk_async_io? I was under the impression
that disk_async_io is only for raw devices.
TIA,
Chris
--------------------------------------------------------------------------------
From: Oracle, Anand Viswanathan 18-Feb-00 07:21
Subject: Re : disk_async_io
Hi,
You can configure for async io in HP machine.
configure async driver and regen HP-UX
kernel
/sbin/mknod /dev/async c 101 0x0
chown oracle:dba /dev/async
chmod 660 /dev/async
Now set the parameter disk_asynch_io=true.
I have observed some problems in setting this to true in 8.0.5.I hope
this are fixed in 8.1.5.
Thanks and Regards
Anand
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 11:05 AM
тАО03-26-2003 11:05 AM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
There has been some issues with some early version of oracle too! Seems like they have been resolved in newer versions (8i+)
basically, to configure you need to:
configure async driver and regen HP-UX kernel
/sbin/mknod /dev/async c 101 0x0
chown oracle:dba /dev/async
chmod 660 /dev/async
Now set the parameter disk_asynch_io=true in your init.ora.
Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 11:28 AM
тАО03-26-2003 11:28 AM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
configure async driver and regen HP-UX kernel
???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 01:04 PM
тАО03-26-2003 01:04 PM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
There is something else you need to do, allow for memory lock allocation in asynchronous mode.
setprivgrp dba MLOCK
dba is the group of the user that owns oracle
or
/etc/privgrp
dba MLOCK
The second solution will handle it at system startup.
Everything else should be okay, don't forget the java patches required for oracle at http://www.hp.com/go/java
And the required OS patches for oracle in doc 43057.1 on metalink.oracle.com
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2004 01:53 AM
тАО02-10-2004 01:53 AM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
FYI, when I enabled this in Oracle and HP-UX, it still didn't use async I/O. I had messages in the Oracle Alert Log (don't remember that exact message). If I remember correctly, further investigation revealed that in HP-UX, you have to use RAW partitions for your Oracle data in order to use Async I/O. I do not want to use raw partitions.
What I ended up doing is disabling the VXFS cache by mounting the Oracle data filesistems with these options:
delaylog,nodatainlog,mincache=direct,convosync=direct
and bumping up the Oracle buffer cache.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2004 04:59 AM
тАО02-10-2004 04:59 AM
Re: Anybody using DISK_ASYNC_IO in Oracle 8i?
Bumping up the Oracle Cache is always a good idea.
In general if you want to use async io, the recommendation is to use it via OS/Kernel-Level.
Just in cases where you cant use it through kernel, you can alternative set up the Oracle Parameters for this.
It is not recommended (I mind to remember even not supported, but not sure about this) to run both, Oracle async configuration AND Kernel async-io.
Hope this helps
Volker