>>>No. Any chance to query the MON$ tables to see what's going on?

>I haven't gone there yet, because they claim rebooting, restoring, etc. makes no difference, but for lack of anything else to try, will get some gstat info, etc. from them when it's running slow again. (Maybe it is a stuck transaction, which just builds up very quickly due to them being very busy...)

OK, GSTAT results (while running slowly this morning)

Database header page information:
Flags 0
Checksum 12345
Generation 839074
Page size 8192
ODS version 11.1
Oldest transaction 838791
Oldest active 838792
Oldest snapshot 838792
Next transaction 838793
Bumped transaction 1
Sequence number 0
Next attachment ID 273
Implementation ID 16
Shadow count 0
Page buffers 3000
Next header page 0
Database dialect 3
Creation date Jun 2, 2011 17:23:14
Attributes force write, no reserve

Variable header data:
Sweep interval: 20000
*END*

The OAT and OIT seem to be fine. I have asked them to change sweep interval from 20 000 to 120 000.

Any idea for what to look at in the monitoring tables exactly?

Thanks
Maya