(no subject)

We originally had a v6 oracle database running fairly slow on a HP 755 Server with 256MB of RAM. The database is about 4GB in size. We migrated to a 384MB RAM K400 Class Server running HP-UX 10.10 with a RAID 5 Disk Architecture. We found that our dual processor K400 machine ran MUCH SLOWER than its 755 Equivalent. (A 90 thousand pound machine running slower than a 40 thousand pound machine!) We switch oracle from running in dual processor mode to uniprocessor mode - this helped a little. We applied a HP patch speed up select statements which had minimal effect. We haven't found any relevant oracle patches.

The problem is that the processors thrash periodically making the db incredibly slow. We have defragged our db and are now running it with a larger SGA, and yet it still runs slower on the K400.
We think that there is a bug in oracle for HP-UX 10.10 because we bought another K400 at the same time to server user file store (120 users) and this is the dogs bollocks for speed.

We are running a package called Service Guard to monitor our K400s - we don't this this is causing an overhead.

We have heard rumours that Oracle is crap on HP-UX 10.10. Is anyone out there having similar performance problems?

-- 
Thanks,
faz.