adding to my earlier post ...

If i pass the hints to do FTS and PARALLEL 6 the same query is taking 4 minutes only.

Thanks,