Performance Issue on Server

[AVV]

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.

[Rita C Workman]

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

[Michael Steele_2]

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.

[Torsten.]

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

[Torsten.]

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

[UVA]

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.

[Michael Steele_2]

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.

[Bill Hassell]

> 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?

[AVV]

Hi,


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