Oracle 10g on HP-UX, Terrible Poor Performance!!

[Delrish]

Dear David & Phillip,

The linux server is not connected to SAN. It uses its local scsi hard disk for storage.
This server has 8G memory and 2*4 swap partition.
c1t2d0 is local hard disk that Hp-UX operating system installed on it.
c6t0d3 & c6t0d4 are two LUNs defined on Disk Array.
Did you see STM resualt in my previous email? Can it a hardware problem?
We did not get Oracle licence for this server yet. We want to sure this solution is good enuogh in performance and than buy Oracle for HP server.
Is it possible that oracle without licence (unregistered databse) be the source of problem. I mean the trial version has some performance problem on HP.

Regards,
Alireza

[Eric Antunes]

Hi Alireza,

Can you post here the output.txt file resulting of the following command:

#ioscan -fn > output.txt

Best Regards,

Eric Antunes

[Delrish]

Eric,

Yes, I will send it for you next week. We are in holidays in our country for 4 days.
Anyway could you help with the questaions that i asked the forum in my previous emails?

Alireza

[Eric Antunes]

Hi,

"Did you see STM resualt in my previous email? Can it a hardware problem?"

That's why I need the ioscan output results: you seem to have hardware problems...

Best Regards,

Eric Antunes

[Binukuttan VM_1]

what is the output of

1.sar -v 1 111
2. vmstat 1 111

see the outputs and try to tune the kernel parameters

good luck
binu

[Alexander M. Ermes]

Hi there.
Try to run Glance in character mode and press the key 'u' .
That will give you an overview over the different phyiscal disks and the load on them.
Rgds
Alexander M. Ermes

[wayne_104]

Hi Alireza

How did you sort out the problem of Oracle 10g on HP-UX, Terrible Poor Performance.

I am having the same issue.

Wayne

[Delrish]

My problem is in VA. I have poor performance on reading from VA. I do not find the root of problem, but I am sure the problem is in VA. I setup some tests and got this result.
Are you sure that your VA is Ok and you have a good performance on it?
There is a benchmark called bonnie. If you would like we can test it on our systems.
If you are interested please download it from http://www.textuality.com/bonnie/
and after compiling, run it with these options: ./bonnie -s 1024 -d "Target directory on VA" -m "Your Machine's name".

We can compare our results with together.

Alireza

[wayne_104]

Hi Alireza

all my disks are internal and there is no IO on them in fact the cpio backup puts more load on the system disks than the database and the application.

I read that the 2004 december patch bundle with phne 31097 is supposed to help.

i am on june 2004 still.

the problem is that the app guys are saying it is os and hardware.

[Delrish]

The root of problem was in Storage system.(VA & SAN Switch)