topic Re: Oracle 8.1.7.0 bad performances over 11.i. Why? in Operating System - HP-UX

Oracle 8.1.7.0 bad performances over 11.i. Why?

Juan Manuel López — Wed, 29 Jan 2003 08:56:47 GMT

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.

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

eran maor — Wed, 29 Jan 2003 09:32:25 GMT

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

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

T G Manikandan — Wed, 29 Jan 2003 09:32:27 GMT

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

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

Yogeeraj_1 — Wed, 29 Jan 2003 10:19:35 GMT

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

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

Juan Manuel López — Wed, 29 Jan 2003 11:01:58 GMT

Thanks to all.
I will try to install the recomended patch.
I will tell you how it works.
Juanma.

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

Juan Manuel López — Wed, 29 Jan 2003 15:57:34 GMT

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.

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

Stefano_10 — Thu, 30 Jan 2003 10:40:37 GMT

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

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

Yogeeraj_1 — Thu, 30 Jan 2003 11:08:43 GMT

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

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

Steven E. Protter — Thu, 30 Jan 2003 20:23:25 GMT

It might be oracle, it might be the os.

Try this data collection script to find out.

P

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

Gus Mestousis — Thu, 24 Jul 2003 22:11:54 GMT

Juanma

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

Thanks

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

twang — Thu, 24 Jul 2003 22:26:05 GMT

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

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

Francisco Pardillo Mart — Mon, 28 Jul 2003 10:08:31 GMT

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)