it's a not local oracle DB and indexing is on!
I don't know if the Hard Disk is working during lagging but I can check this on customer side today afternoon.
We just recognised the following:
On requesting the console the usertool is working with cpu upt to 70%
then the server's working with up to 80%
after this, both of them are waiting
minutes later the usertool is getting the data.
but the DB isn't working hard...
recon job becomes slow when there is a huge DSO backlog. This u can check using the SQL command
SELECT count(*) from distributed_pending;
This value should keep on decreasing. If not then it means that DSO processing is hanged. So you need to restart the DSO by killing the process
"Serverds" in the task manager.
Try this, it might work.