DSXchange

Hi,
I have a job in production which has been running fine all the days.

This morning I found that it was running at 10 rows per sec.

I stopped the job and started again. I noticed that it started with 300 rows per sec and slowly started to drop and after 5 minutes, it is showing me 10 rows per second.

Can you guide me as to why the rows per second dropped.

I am doing an update to the Oracle table.


Thanks
ketfos

With no specifics, all we can do is guess - and my guess is full table scan from updates on non-indexed columns.

yes, I should have been some specific.

The problem was in the new index created on the table, which we found when we did Explain Query Plan.

The index was removed and update process took normal time.

thanks

Ketfos

Then please mark the post as Resolved using the button at the top of the screen.