Thanks akas_chauhan for sharing your view. For the time being, I did rewrite the query, couldn't avoid the FTS though. And also changed the disk (as advised by our IT team). Seems like we'd problem with the disk itself. The query has finished within the regular time.

gtcol