Performance degraded after new year!!

[Andreas D. Skjervold]

Hi!
In our production system we are having some performance problems.
The system is running on hp-ux 10.20 on a K-class server, with Oracle 8.0.5 databases processing telecom data by the millions pr day.
The performance was suddenly degraded to a low 30 % of the baseline performance from last year.
This happened on january 01 2001 at 00:00 GMT!!! and has remained as such.

The production team is currently working on this in cooperation with the different software vendors.

As sysadm for the telecom developers I wanted to post this question to check if there's anyone out there that have experienced or heard of similar occurances.

Heard of anything like it??

Andreas

[Paula J Frazer-Campbell]

Hi
I presume that you patched fully for the Y2K thing.
If not then I suggest you do so.
Why you may ask -

I would guess that a 1 year lookback could be to blame,
ie somthing in your system is looking backwards and at 00:00 01/01/2001 looked back to 00:00 01/01/2000.
As it is still running albeit slow I would say that it is resolving the problem but not very well.
Does the processed data involve time/data stamps and if so is the post Y2001 data correct.

Just an idea

Paula

[Tim Malnati]

I agree with Paula on this. If you find that all your patching is up to date, I would definitely get Oracle support involved too. It's quite possible that there is a Y2K issue that was missed and the volume that you are processing has caused the beast to become painfully known.

[Andreas D. Skjervold]

Hi again!
After closer examination, it turns out that the change didn't occure so suddenly as it first seemed. It happened gradually over a couple of hours as the telecom data with the new years timestamp started to arrive.
This implies a possible problem with the application or the Oracle indexes that includes the timestamp.

So; hp-ux might not be to blame, but thanks for the input anyway.

rgds
Andreas