Here are two runs of the same SQL from different programs. The top is an automated process, the bottom is Toad. (SQL is the same, but SQL_ID is different because of white space issues):
So why is one finished in 7.2 minutes and one still at 4.7 hours and still counting up?