4 Replies Latest reply on Aug 7, 2019 8:32 AM by Matthias_H

    SQL Developer 19.2 slow connecting to CDB - Solved

    3352125

      SQL Developer 19.2 (Linux) - Java 1.8.0.221 also tested with Java 11.0.2. Tested using 12.2.0.1 cdb/pdb database on external server (linux)

      The database used for testing is 12.2.0.1 Standard edition and has only 1 pluggable database attached to the container.

       

      Issue is when connecting to a container database (CDB) the process is very slow.

       

      SQL Developer 19.2

      Connecting to 12.2.0.1 CDB completes in 3 minutes.

      Connection to 12.2.0.1 PDB completes in 10 seconds.

       

      SQL Developer 19.1

      Connecting to 12.2.0.1 CDB completes in 10 seconds.

      Connection to 12.2.0.1 PDB completes in 10 seconds.

       

      sqlnet.ora

      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

       

      The connecting issue is strange as SQL Developer 19.1 connection time is consistent for both the CDB/PDB

       

      Any suggestions on correcting the issue would be appreciated.

       

      For now I have reverted back to 19.1

       

      Thanks.

       

      Solution: Tools -> Preferences -> Code Editor -> Completion Insight -> uncheck Completion Auto-Popup in SQL Worksheet

      After making the change connection to CDB works correctly - no delay.

      Tested against 12.2 and 18.0