Operating System - HP-UX
1748013 Members
3709 Online
108757 Solutions
New Discussion юеВ

Oracle7.3.4.5 and HP-UX 10.20 performance Issues

 
Pascale Jacques
Occasional Contributor

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
3 REPLIES 3
Albert E. Whale, CISSP
Honored Contributor

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.
Sr. Systems Consultant @ ABS Computer Technology, Inc. http://www.abs-comptech.com/aewhale.html & http://www.ancegroup.com
Steve Slade
Frequent Advisor

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.
If at first you do not succeed. Destroy all evidence that you even attempted.
Pascale Jacques
Occasional Contributor

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?