Hi,
I'm having a weird situation since db upgrade. After upgrading our database from 11g to 12c, a specific query using an external dblink hangs forever.
The thing is, when i run the query from my local computer with SQL Developer or toad, the query finished within 3-4 seconds. But the things are different when we query the same sql from oracle discoverer, ebs or via web service.
When i check the sql session it would wait on "DB: Sequential File Read" forever. I can only query the sql from my local sql IDE.
I have compared the sql plan for both different sessions no difference. One would end in seconds, the other one goes on forever. Do you have any idea ?
Thanks