Here is the full statspack during NORMAL operations. I will arrange with users to run a stress test today (Monday) and take a new snapshot during that.

sp_7575_7576.txt

Thanks for your help.

P.S. I apologise for the SQL - it's not mine! As I have said, the "developers" did not read the PL/SQL manual when they wrote the system - only using Oracle as a 'bit bucket'. I have it under oath that they have now read the manual and the next version will be more sympathetic.

Also, the app is written in COBAL. If you think I'm going anywhere near that then you can...

Tamil, we have a good relationship with the developers and they do take on board our observations. But we won't be able to do any SQL code changes to this version of the system.