1 Reply Latest reply on Mar 4, 2015 12:56 PM by thatJeffSmith-Oracle

    SQL Developer Query Hangs Connection and Machine Specific

    KickMumford

      I have an unusual problem and have been unable to find a solution. I am using SQL developer 4.0.3 to connect to 3 different environments at my work. I am running the same query in all environments. The query will return results in production in less than 2 minutes. When any user tries to run the query on my machine in the test environment it just keeps running and no results are returned (keeps running not empty record set). I am able to run the query through excel to the same environment from the same machine with my credentials and can run the query in sql developer using my credentials on other machines.

       

      That leads me to believe this is machine specific and specific to my particular instance of sql developer. I have tried playing around with the NLS settings without much luck. I have installed the most recent versions of sql developer, jre, and jdk. If anyone else has any suggestions please let me know or if additional information is required to troubleshoot.