- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle7.3.4.5 and HP-UX 10.20 performance Issu...
Operating System - HP-UX
1757004
Members
2035
Online
108858
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО11-20-2000 08:01 PM
тАО11-20-2000 08:01 PM
Oracle7.3.4.5 and HP-UX 10.20 performance Issues
I recently upgraded to 7.3.4.5 on T600 12cpus. Queries that take 3 minutes on my Kbox running 7.3.3.5.1 take over 5 hours on the T600 running 7.3.4.5. A bug filed with Oracle claims this is an OS issue with libcma and DCE. The 7.3.3.5.1 db was not using DCE threads. The bug# in oracle is 924054 followed by bug# 998964. Oracle is asking to upgrade to UX11. There has to be a better way as this is not a solution right now.
Has any one seen this problem? What was the solution?
Thanks
Has any one seen this problem? What was the solution?
Thanks
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2000 08:17 PM
тАО11-20-2000 08:17 PM
Re: Oracle7.3.4.5 and HP-UX 10.20 performance Issues
Pascale,
I do not know the specifics on the Oracle Bug numbers you present. However, I would like to recommend that you attempt to change the indexes or re-index the databases to see if this alleviates your problem.
Hope that helps.
I do not know the specifics on the Oracle Bug numbers you present. However, I would like to recommend that you attempt to change the indexes or re-index the databases to see if this alleviates your problem.
Hope that helps.
Sr. Systems Consultant @ ABS Computer Technology, Inc. http://www.abs-comptech.com/aewhale.html & http://www.ancegroup.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-21-2000 02:52 AM
тАО11-21-2000 02:52 AM
Re: Oracle7.3.4.5 and HP-UX 10.20 performance Issues
Pascale,
We use Oracle 7.3.4 (not 7.3.4.5) on our K series and have seen no noticeable performance issues. I have had a look at the bug you quoted on Oracle's Metalink site, (do you have access to this site - highly recommended- you get to see the full internals of bugs/bug analysis) (http://metalink.oracle.com/).
If you are suffering from the bug you quoted, then it seems that you have very little options. Looking at Metalink, I saw that Oracle found that the execution plans for queries under 7.3.2 and 7.3.4 are the same. What is different is that the Oracle code for 7.3.4 is compiled using a different set of I/O calls,(in libcma), and these are the root cause of your problems. According to HP these calls are part of the kernel in HPUX11, and have no performance issues for Oracle. The only thing you could try and do is try and limit the I/O calls - basically almost impossible - but you could try increasing the size of your buffer cache, so hopefully you might make slightly less I/O disk calls - though probably not a noticeable amount.
We use Oracle 7.3.4 (not 7.3.4.5) on our K series and have seen no noticeable performance issues. I have had a look at the bug you quoted on Oracle's Metalink site, (do you have access to this site - highly recommended- you get to see the full internals of bugs/bug analysis) (http://metalink.oracle.com/).
If you are suffering from the bug you quoted, then it seems that you have very little options. Looking at Metalink, I saw that Oracle found that the execution plans for queries under 7.3.2 and 7.3.4 are the same. What is different is that the Oracle code for 7.3.4 is compiled using a different set of I/O calls,(in libcma), and these are the root cause of your problems. According to HP these calls are part of the kernel in HPUX11, and have no performance issues for Oracle. The only thing you could try and do is try and limit the I/O calls - basically almost impossible - but you could try increasing the size of your buffer cache, so hopefully you might make slightly less I/O disk calls - though probably not a noticeable amount.
If at first you do not succeed. Destroy all evidence that you even attempted.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-25-2000 04:17 PM
тАО11-25-2000 04:17 PM
Re: Oracle7.3.4.5 and HP-UX 10.20 performance Issues
I reviewed the bug in metalink. I reviewed both explain plans and the execution plans are identical except the 7.3.4.5 db spends 4.5 hours in the fetch phase compared to the 7.3.3 db which spends 1.5 minutes in the same phase.
This does not make sense to me. How do I find out if HP has any DCE or patches associated with this issue?
This does not make sense to me. How do I find out if HP has any DCE or patches associated with this issue?
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP