Thank you for the resources. Actually I checked the profile and it was the query issue. The query was running forever on the oracle side and never returned the dataset. Once that was tunes, everything else was fixed.