Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.1.7.0 bad performances over 11.i. Why?

Juan Manuel López
Valued Contributor

Oracle 8.1.7.0 bad performances over 11.i. Why?

I have an Oracle 8.1.7 over hpux 11.i and I get very bad performance when I try to make an update to database.
Otherwise, the same database over other machine, ( smaller ), running 11.0 goes very fast.
I have been looking for information and I have found something about install patches like PHSS_24303 over 11.00, so witch is the patch to 11.i. ( this is because I think the problem could be I need to install some patch ).
Please, Help.
Thanks in advance.
Juanma.
I would like to be lie on a beautiful beach spending my life doing nothing, so someboby has to make this job.
11 REPLIES
eran maor
Honored Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

Hi

this is the recommend patches for oracle 8.1.7 to hp-ux 11.11

6. C++ runtime libs
Current Revision of Patch:
PHSS_26946 - s700_800 11.11 HP aC++ -AA runtime libraries (aCC A.03.37)
Patch in latest Support Plus Patch Bundle? Yes, as PHSS_22898.

5. asyncio driver patch
- slow database startup with large SGAs
Current Revision of Patch:
PHKL_25506 - s700_800 11.11 asyncio driver patch
Patch in latest Support Plus Patch Bundle? Yes, as PHKL_25506.

4. ONC/NFS General Release/Performance Patch
Current Revision of Patch:
PHNE_26388 - s700_800 11.11 ONC/NFS General Release/Performance Patch
Patch in latest Support Plus Patch Bundle? Yes, as PHNE_26388.

3. ld and linker tools cumulative patch
Current Revision of Patch:
PHSS_26560 - s700_800 11.11 ld(1) and linker tools cumulative patch
Patch in latest Support Plus Patch Bundle? No.

2. libc cumulative patch
Current Revision of Patch:
PHCO_27740 :s700_800 11.11 libc cumulative patch
Patch in latest Support Plus Patch Bundle? Yes, as PHCO_25452.

1. libc cumulative header file patch
Current Revision of Patch:
PHCO_24402 :s700_800 11.11 libc cumulative header file patch
Patch in latest Support Plus Patch Bundle? Yes, as PHCO_24402.


please also give us the output of the kmtune -l
and alos tell us if you can see what is overload when your perforamce is not good
love computers
T G Manikandan
Honored Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

i would check these

1.check the kernel parameters as whether they are properly tuned.
you can cross check the two systems.
One of the imp. parameter is the buffer cache parameter.
The default value is half the memory allocated.
dbc_max_pct.Make sure that you bring this value down.

2.How about the swap setup?
3.How about the I/O distribution for the database.
Have you distibuted the datafiles and logfiles accordingly.Were you running asynchronous mode on the other server/Were there any extra mount options in the 11.0 server for good performance.

2.How about the Oracle database setup.
Are the Initialization parameters in the init.ora file Okay,like shared_pool size and other parameters?
check whether the database on 11.0 running on dedicated or shared server mode?
check whether the temp and rollback segments are okay in the database?

check and revert
Yogeeraj_1
Honored Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

hi,

1. Are you running MTS or dedicated server mode?

2. What is the database initiation parameters? Are they the same?

3. have you applied the latest available patchset for the base release 8.1.7? i.e. 8.1.7.4 PATCH SET

Please post these details.

Thanks
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Juan Manuel López
Valued Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

Thanks to all.
I will try to install the recomended patch.
I will tell you how it works.
Juanma.
I would like to be lie on a beautiful beach spending my life doing nothing, so someboby has to make this job.
Juan Manuel López
Valued Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

There is not a overload problem, The disk it is not doing many things, the swap is normal, the procesors is normal over 35%.
The problem is that Oracle updates run very slow.
I would like to be lie on a beautiful beach spending my life doing nothing, so someboby has to make this job.
Stefano_10
Advisor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

Use this sql script from sqlplus to extract information about your db performance.
You could compare the results between the two server and verify if db parameters are correctly setted up.
Stefano
Yogeeraj_1
Honored Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

hi juanma,

The other thing you can do now is to enable timed_statistics and run a Statspack report.

If you have already located the program which is causing the problem, try to use SQL TRACE and analyze the tkprof output.

If you need further help, let us know.

Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

It might be oracle, it might be the os.

Try this data collection script to find out.

P
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Gus Mestousis
Frequent Advisor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

Juanma

We are experiencing the same problem with very slow Oracle updates. I was wondering if you ever resolved this issue.

Thanks

Sure, let me just drop everything and work on your problem.
twang
Honored Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

Hi,
In addition to above replies, I would like to look at the oracle first, could you upload BSTAT/ESTAT or STATSPACK files?
Regards
Francisco Pardillo Mart
Occasional Contributor

Re: Oracle 8.1.7.0 bad performances over 11.i. Why?

Hi,

We had the same problem (hp-ux 11i 64Bits), the performance laked into a dramatic situation, (all was fine, the optimized showed us good plans, the server was fine ...), we just had to aply the Oracle patchset: 8.1.7.3 and, finaly we found a patch : p2245790_8173_HP64.zip from metalink (metalink.oracle.com) that mended this situation. Now, the performance is really good.

(Excuse my english, i??m spanish)

Frank