rows per sec drops form 300 to 10

ketfos · Post by **ketfos** » Sat Apr 25, 2009 9:33 am

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

chulett · Post by **chulett** » Sat Apr 25, 2009 1:21 pm

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

ketfos · Post by **ketfos** » Sat Apr 25, 2009 5:30 pm

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

chulett · Post by **chulett** » Sat Apr 25, 2009 10:15 pm

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