Benchmark tests

[Carlo Henrico_1]

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.

[John Palmer]

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.

[Carlo Henrico_1]

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.

[John Palmer]

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

[Devbinder Singh Marway]

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