topic Re: Performance Issue on Server in Operating System - HP-UX

Performance Issue on Server

AVV — Fri, 12 Feb 2010 11:51:22 GMT

Hi,

I am trying to install the Oracle Release 12.11 on an ia server. 11iv3 ,ia64 hp server rx3600. and top shows as ok to me but Oracle installation goes very slow. The outputs are attached.

8GB memory and 16Gb swap. 2 processors.

Re: Performance Issue on Server

Rita C Workman — Fri, 12 Feb 2010 18:35:30 GMT

I don't run Oracle 12, so I guess I'd suggest finding out what Oracle recommendations for kernel parms are. Likely you need to adjust some.

I know for installations they always want maxdsiz increased, at least for the install.

Just a quick thought,
Rita

Re: Performance Issue on Server

Michael Steele_2 — Fri, 12 Feb 2010 19:10:40 GMT

Hi

cimprovagt, apart of cimserver, wbem, and other Ia64 diagnostic utilities.

Verify that you are up to date with your online diags. which include this process.

All other oracle related processes are in a state of unzipping, which may be normal for a new install.

2 pts/0 7823 oracrp 128 20 10328K 2028K sleep 0:17 0.98 0.98 unzip
2 pts/0 7822 oracrp 128 20 10328K 2028K sleep 0:13 0.61 0.61 unzip
2 pts/0 7824 oracrp 128 20 10328K 2028K sleep 0:15 0.60 0.60 unzip
2 pts/0 5145 root 152 20 1290M 204M run 1:15 0.56 0.56 java
2 pts/0 7820 oracrp 128 20 10328K 2028K sleep 0:14 0.55 0.55 unzip
2 pts/0 7821 oracrp 128 20 10328K 2028K sleep 0:17 0.51 0.51 unzip
2 ? 60 root 152 20 21168K 18816K run 0:19 0.40 0.40 vxfsd
2 pts/0 6245 oracrp 152 20 745M 86832K run 0:07 0.37 0.37 java

Rita's advice about kernel parameters is also on target. Oracle should be telling you what to set a dozen kernel parameters at least.

Re: Performance Issue on Server

Torsten. — Fri, 12 Feb 2010 20:01:39 GMT

Installation from CD/DVD is slow? Do you already use the new USB 2 driver???

Re: Performance Issue on Server

Torsten. — Fri, 12 Feb 2010 20:08:29 GMT

https://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=USB2

Re: Performance Issue on Server

UVA — Fri, 12 Feb 2010 21:58:12 GMT

HI am AVV's Colleague,

Yes it is from Installation from DVD, Please let us know why the unzip is in sleep stat
" 2 pts/0 7823 oracrp 128 20 10328K 2028K sleep 0:17 0.98 0.98 unzip "

since we have almost 90% of cpu is free and &gb of memory free.

Re: Performance Issue on Server

Michael Steele_2 — Sat, 13 Feb 2010 00:15:40 GMT

HI:

Well as Torsten is pointing out, a dvd installation is going to take a lot longer time. I remember dd'ing 2 gb between dvd and disk and then from disk and disk and noticed a 20 minute difference.

You've got 6 or so unzip processes running and what does unzip do? It writes. If you run a sar -d 5 5 you'll probably see a disk bottleneck.

As for the sleep state, one unzip process is ahead of this one awaiting its turn to write to a block that another process has opened.

Re: Performance Issue on Server

Bill Hassell — Sat, 13 Feb 2010 01:36:09 GMT

> but Oracle installation goes very slow.

Compared to what? Have you installed version 12 on a similar system? Perhaps it is supposed to take 30 hours? What does Oracle say is a normal install time? sar -d 2 10 might be useful to see if the disks are busy or idle. Does version 12 install require a working network?

Re: Performance Issue on Server

AVV — Mon, 15 Feb 2010 17:40:02 GMT

Hi,

So far nothing worked and decided to move up with another server with higher configuration. Thanks all for sharing ideas with me.