- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8i Hp-UX Vertias Quick IO and async wri...
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
тАО10-27-2004 05:50 PM
тАО10-27-2004 05:50 PM
Oracle 8i Hp-UX Vertias Quick IO and async writes
I have a database which uses vertias async devices using Quick IO. The quick IO allows use of cooked files and file systems. The devices have been created using the usual qio admin utility and then the tablespaces are created from those files.
The database and kernel parameters have been setup as per instructions.
A truss on the DBWR process shows the usual write and read but no kaio sys calls.
qiostat is giving very strange readings in the millions if read/writes for the files and fuser doesn't show any process having a hold on the qio files.
So how can I determine whether there is actually any async io?
Thanks,
Michael.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2004 08:11 PM
тАО10-27-2004 08:11 PM
Re: Oracle 8i Hp-UX Vertias Quick IO and async writes
read the doc:
"Best practices for Oracle on HP-UX"
http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt
Regards,
Zygmunt
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2004 10:08 PM
тАО10-27-2004 10:08 PM
Re: Oracle 8i Hp-UX Vertias Quick IO and async writes
You need raw devices to use async I/O.
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2004 11:16 AM
тАО10-31-2004 11:16 AM
Re: Oracle 8i Hp-UX Vertias Quick IO and async writes
Thanks for your replies.
Zygmunt, as mentioned above in my original question the database and kernel parameters have already been setup.
Eric, Quick IO from Veritas allows async on cooked devices. That is its purpose.
Again, the big question is I have everything setup to use Async IO but nothing in Truss of the database processes points to actual async IO (i.e. no evidence of kaio just write or read). How can I categorically determine whether Async IO is active?
Thanks
Michael.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2004 01:47 PM
тАО10-31-2004 01:47 PM
Re: Oracle 8i Hp-UX Vertias Quick IO and async writes
Oracle 8.1.5 and above use async i/o by default. There are a few steps to making it work right on HP-UX, but thats in the best practices document.
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
тАО10-31-2004 03:23 PM
тАО10-31-2004 03:23 PM
Re: Oracle 8i Hp-UX Vertias Quick IO and async writes
Thanks for your response. Do you know of a method such as qiostat or truss that could identify async io is taking part or does truss on hp-ux only report read , write and not make distinctions about async io?
Thanks,
Michael.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2004 03:15 PM
тАО11-03-2004 03:15 PM
Re: Oracle 8i Hp-UX Vertias Quick IO and async writes
Thanks for your responses but I found the answer else where.
Regards,
Michael.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2004 03:18 AM
тАО11-17-2004 03:18 AM