Problem: Query using Oracle temp table is hanging.
Even in SQL Editor, tried to run query, which is joining the result with Oracle Temp Table, is taking too long time.
This is not consistent…
Solution: After all the monkey business, recreated the temp tables. It is working fine.
It happen few times. Recreated and problem solved. Still dont know what is happening behind the door.