topic Benchmark tests in Operating System - HP-UX

Benchmark tests

Carlo Henrico_1 — Thu, 05 Oct 2000 10:29:51 GMT

We are running performance benchmarks on HP-UX 11.0 with Oracle 8.1.5 and MQSeries 5.1. Certain tests are only to MQSeries and others only to Oracle.

There is one strange consistency between these tests. Every so many transactions takes 8 seconds whereas the rest takes 0.05 to 0.4 seconds per transaction.

Any ideas where I can start looking. These transactions which take 8 seconds are not evenly spaced and sometimes in a batch of 100 transactions none occur and yet other batches up to 6 take 8 seconds.

Thank you.

Re: Benchmark tests

John Palmer — Thu, 05 Oct 2000 10:39:17 GMT

Keeping a close eye on system performance with 'glance' would be my first suggestion.

If you haven't purchased it, you can install a trial version from the Applications CD disk 2.

Re: Benchmark tests

Carlo Henrico_1 — Thu, 05 Oct 2000 11:01:10 GMT

Thanks John, however, my Glance is open permanently with between 1 and 5 second interval time. According to Glance the system seems to be cruising along at a steady 95%+ idle.

We do have an HPARRAY 12H - I have a suspicion there may be something funny there.

Re: Benchmark tests

John Palmer — Thu, 05 Oct 2000 11:10:08 GMT

Well it certainly doesn't sound like a CPU problem then.

Could it be related to Oracle doing a log switch and or checkpoint? This can cause a lot of disk activity. Also it's not a good idea having your Oracle redo log files on Autoraid.

Check your Oracle alert log for log switches.

I'd also concentrate on disk I/O with glance (d u and i screens).

Regards,
John

Re: Benchmark tests

Devbinder Singh Marway — Thu, 05 Oct 2000 11:12:10 GMT

Could it be that some transactions are larger than others hence take longer to process?

Can you monitor ORACLE , get a snap shot every 5 minutes or so and see what is being processed , see the size of the records etc..