MAX(TIMESTAMP)
-------------------
2011-08-25 11:55:25
Elapsed: 00:00:00.02
COUNT(*)
----------
8165543
after running the job for 55 hours, the MAX(TIMESTAMP) advanced 3 hours.
Elapsed: 55:28:30.66
MAX(TIMESTAMP)
-------------------
2011-08-25 14:42:59
I decided that it was more useful to be able to generate current statistics in the courses, and purged the 8.5 million rows in the activity_accumulator_queue table.
17:38:32 SQL> delete from activity_accumulator_queue where timestamp <= sysdate -1;
]]>
