1 2 Previous Next 21 Replies Latest reply on Apr 17, 2017 7:44 PM by Gary Graham-Oracle

    Export/Browse window in SQL Developer takes a long time to come up!

    1002330

      Hello All,

      I am using SQL developer version 4.1.5 and it has started acting weird whenever I click on the folder icon, or try to "Export" the result in a file or "Browse" for a file within the developer. It takes a long time...I mean a min for the window to come up. Once the window comes up, everything works as it should be. I do click ctrl+A so that I grab ALL the data BEFORE exporting it..but no change. It started happening gradually. The time it took to open the export or the file explorer window gradually increased if I remember correctly. Please help!! and Thanks!

        • 1. Re: Export/Browse window in SQL Developer takes a long time to come up!
          Prannoy Prashad-Oracle

          Hi !

           

          How about doing right click on Query Result and then clicking on Export ? Does that also takes time.

          • 2. Re: Export/Browse window in SQL Developer takes a long time to come up!
            1002330

            Hi Prannoy,

            I am sorry, that is what I meant in my original post. When I right click on the query result, it takes a long time for the window to come up. I did not know if there was any other way to export the result. This happens when I go File > Open or use the keyboard shortcut "Ctrl+O" as well. Thanks for your help!

            • 3. Re: Export/Browse window in SQL Developer takes a long time to come up!
              Brian Jeffries-Oracle

              Since it's happened gradually, maybe the disk it is opening is filling up or the directory has many many entries?

              • 4. Re: Export/Browse window in SQL Developer takes a long time to come up!
                1002330

                Hmm...I dont know. All the drives which I am trying to open through SQL Developer have a lot of space available. More than 50% to be precise. I dont remember this happening in the older version of developer.

                • 5. Re: Export/Browse window in SQL Developer takes a long time to come up!
                  thatJeffSmith-Oracle

                  I've seen this happen before, but the slow open time only happened the first time.

                   

                  After you wait the minute, if you try to do another export or just open the export dialog again, does it take another minute?

                  • 7. Re: Export/Browse window in SQL Developer takes a long time to come up!
                    1002330

                    I have timed it several times and it takes somewhere between 35 - 40 sec to open the dialog box.

                    • 8. Re: Export/Browse window in SQL Developer takes a long time to come up!
                      thatJeffSmith-Oracle

                      there's a program, jstack, in your jdk home

                       

                      you can run it from the CLI and send it the process ID of sqldev - it will generate a stack dump. share that here and we can see what's going on.

                      • 9. Re: Export/Browse window in SQL Developer takes a long time to come up!
                        1002330

                        Here it is -

                         

                        "Active Reference Queue Daemon" #18 daemon prio=1 os_prio=-2 tid=0x0000000016a1e

                        000 nid=0xa70 in Object.wait() [0x000000001774f000]

                           java.lang.Thread.State: WAITING (on object monitor)

                                at java.lang.Object.wait(Native Method)

                                at java.lang.Object.wait(Object.java:502)

                                at org.openide.util.lookup.implspi.ActiveQueue.removeBetter(ActiveQueue.

                        java:225)

                                at org.openide.util.lookup.implspi.ActiveQueue.access$400(ActiveQueue.ja

                        va:57)

                                at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.ja

                        va:180)

                                - locked <0x00000000ce54efa0> (a java.lang.ref.ReferenceQueue$Lock)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "TimerQueue" #16 daemon prio=5 os_prio=0 tid=0x0000000016868000 nid=0x1f00 runna

                        ble [0x00000000188ef000]

                           java.lang.Thread.State: TIMED_WAITING (parking)

                                at sun.misc.Unsafe.park(Native Method)

                                - parking to wait for  <0x00000000ce85d238> (a java.util.concurrent.lock

                        s.AbstractQueuedSynchronizer$ConditionObject)

                                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215

                        )

                                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject

                        .awaitNanos(AbstractQueuedSynchronizer.java:2078)

                                at java.util.concurrent.DelayQueue.take(DelayQueue.java:223)

                                at javax.swing.TimerQueue.run(TimerQueue.java:174)

                                at java.lang.Thread.run(Thread.java:745)

                         

                           Locked ownable synchronizers:

                                - <0x00000000ce85d260> (a java.util.concurrent.locks.ReentrantLock$Nonfa

                        irSync)

                         

                        "AWT-EventQueue-0" #15 prio=6 os_prio=0 tid=0x00000000167d3800 nid=0x1fdc runnab

                        le [0x000000001764c000]

                           java.lang.Thread.State: RUNNABLE

                                at java.io.WinNTFileSystem.checkAccess(Native Method)

                                at java.io.File.canRead(File.java:768)

                                at oracle.ide.net.FileURLFileSystemHelper.canRead(FileURLFileSystemHelpe

                        r.java:130)

                                at oracle.ide.net.URLFileSystemHelperDecorator.canRead(URLFileSystemHelp

                        erDecorator.java:89)

                                at oracle.ide.net.URLFileSystemHelperDecorator.canRead(URLFileSystemHelp

                        erDecorator.java:89)

                                at oracle.ideimpl.net.LazyURLFileSystemHelperDecorator.canRead(LazyURLFi

                        leSystemHelperDecorator.java:122)

                                at oracle.ide.net.URLFileSystemHelperDecorator.canRead(URLFileSystemHelp

                        erDecorator.java:89)

                                at oracle.ide.net.URLFileSystem.canRead(URLFileSystem.java:282)

                                at oracle.dbtools.raptor.utils.URLChooserShortcuts.isValidURL(URLChooser

                        Shortcuts.java:199)

                                at oracle.dbtools.raptor.utils.URLChooserShortcuts.addIfExists(URLChoose

                        rShortcuts.java:211)

                                at oracle.dbtools.raptor.utils.URLChooserShortcuts.addIfExists(URLChoose

                        rShortcuts.java:203)

                                at oracle.dbtools.raptor.utils.URLChooserShortcuts.initialize(URLChooser

                        Shortcuts.java:149)

                                - locked <0x00000000cfbbd308> (a oracle.dbtools.raptor.utils.URLChooserS

                        hortcuts)

                                at oracle.dbtools.raptor.utils.URLChooserShortcuts.createShortcuts(URLCh

                        ooserShortcuts.java:69)

                                at oracle.ide.dialogs.DialogUtil.addShortcutButtons(DialogUtil.java:240)

                         

                                at oracle.ide.dialogs.DialogUtil.initURLChooser(DialogUtil.java:160)

                                at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:12

                        4)

                                at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:11

                        4)

                                at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:11

                        0)

                                at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:10

                        6)

                                at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.<init>(UR

                        LFileChooser.java:831)

                                at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.<init>(UR

                        LFileChooser.java:889)

                                at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URL

                        FileChooser.java:794)

                                at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(

                        TargetOptionsPanel.java:237)

                                at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetO

                        ptionsPanel.java:63)

                                at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetO

                        ptionsPanel.java:55)

                                at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>

                        (ExportWizDestinstaionPanel.java:98)

                                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                         

                                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

                        orAccessorImpl.java:62)

                                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

                        onstructorAccessorImpl.java:45)

                                at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

                                at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java

                        :315)

                                at oracle.ide.wizard.Step.newTraversable(Step.java:171)

                                at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)

                                at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)

                                at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)

                                at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:121)

                                at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(Export

                        WizMain.java:226)

                                at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(Expor

                        tWizMain.java:204)

                                at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid

                        (TableExportAction.java:73)

                                at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPe

                        rformed(ExportGrid.java:165)

                                at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:20

                        22)

                                at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav

                        a:2348)

                                at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel

                        .java:402)

                                at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259

                        )

                                at javax.swing.AbstractButton.doClick(AbstractButton.java:376)

                                at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:8

                        33)

                                at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMen

                        uItemUI.java:877)

                                at java.awt.Component.processMouseEvent(Component.java:6533)

                                at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

                                at java.awt.Component.processEvent(Component.java:6298)

                                at java.awt.Container.processEvent(Container.java:2236)

                                at java.awt.Component.dispatchEventImpl(Component.java:4889)

                                at java.awt.Container.dispatchEventImpl(Container.java:2294)

                                at java.awt.Component.dispatchEvent(Component.java:4711)

                                at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888

                        )

                                at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)

                         

                                at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)

                                at java.awt.Container.dispatchEventImpl(Container.java:2280)

                                at java.awt.Window.dispatchEventImpl(Window.java:2746)

                                at java.awt.Component.dispatchEvent(Component.java:4711)

                                at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

                                at java.awt.EventQueue.access$500(EventQueue.java:97)

                                at java.awt.EventQueue$3.run(EventQueue.java:709)

                                at java.awt.EventQueue$3.run(EventQueue.java:703)

                                at java.security.AccessController.doPrivileged(Native Method)

                                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionP

                        rivilege(ProtectionDomain.java:76)

                                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionP

                        rivilege(ProtectionDomain.java:86)

                                at java.awt.EventQueue$4.run(EventQueue.java:731)

                                at java.awt.EventQueue$4.run(EventQueue.java:729)

                                at java.security.AccessController.doPrivileged(Native Method)

                                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionP

                        rivilege(ProtectionDomain.java:76)

                                at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

                                at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQu

                        eueWrapper.java:169)

                                at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQue

                        ueWrapper.java:151)

                                at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre

                        ad.java:201)

                                at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.

                        java:116)

                                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre

                        ad.java:105)

                                at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

                         

                                at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

                                at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "AWT-Windows" #13 daemon prio=6 os_prio=0 tid=0x00000000167f4800 nid=0x530 runna

                        ble [0x000000001734f000]

                           java.lang.Thread.State: RUNNABLE

                                at sun.awt.windows.WToolkit.eventLoop(Native Method)

                                at sun.awt.windows.WToolkit.run(WToolkit.java:306)

                                at java.lang.Thread.run(Thread.java:745)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "AWT-Shutdown" #12 prio=5 os_prio=0 tid=0x00000000167f3000 nid=0xc4c in Object.w

                        ait() [0x000000001724f000]

                           java.lang.Thread.State: WAITING (on object monitor)

                                at java.lang.Object.wait(Native Method)

                                at java.lang.Object.wait(Object.java:502)

                                at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:295)

                                - locked <0x00000000ce8706a8> (a java.lang.Object)

                                at java.lang.Thread.run(Thread.java:745)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "Java2D Disposer" #11 daemon prio=10 os_prio=2 tid=0x0000000016803800 nid=0x2144

                        in Object.wait() [0x000000001714f000]

                           java.lang.Thread.State: WAITING (on object monitor)

                                at java.lang.Object.wait(Native Method)

                                at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)

                                - locked <0x00000000ce819ad0> (a java.lang.ref.ReferenceQueue$Lock)

                                at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)

                                at sun.java2d.Disposer.run(Disposer.java:148)

                                at java.lang.Thread.run(Thread.java:745)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "Service Thread" #9 daemon prio=9 os_prio=0 tid=0x0000000015cee000 nid=0x1efc ru

                        nnable [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "C1 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x0000000015c8b800 nid=0x20a

                        c waiting on condition [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x0000000015c8a000 nid=0x126

                        0 waiting on condition [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x0000000015c86000 nid=0x169

                        8 waiting on condition [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x00000000148b6000 nid=0x2074 w

                        aiting on condition [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x00000000148b4800 nid=0x218c

                        runnable [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x00000000148a0000 nid=0x22f8 in Obje

                        ct.wait() [0x0000000015baf000]

                           java.lang.Thread.State: WAITING (on object monitor)

                                at java.lang.Object.wait(Native Method)

                                at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)

                                - locked <0x00000000ce352ec8> (a java.lang.ref.ReferenceQueue$Lock)

                                at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)

                                at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:209)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000014858800 nid=0x500

                        in Object.wait() [0x0000000015aaf000]

                           java.lang.Thread.State: WAITING (on object monitor)

                                at java.lang.Object.wait(Native Method)

                                at java.lang.Object.wait(Object.java:502)

                                at java.lang.ref.Reference.tryHandlePending(Reference.java:191)

                                - locked <0x00000000ce342d40> (a java.lang.ref.Reference$Lock)

                                at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:153)

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "main" #1 prio=5 os_prio=0 tid=0x000000000232c800 nid=0x648 waiting on condition

                        [0x0000000000000000]

                           java.lang.Thread.State: RUNNABLE

                         

                           Locked ownable synchronizers:

                                - None

                         

                        "VM Thread" os_prio=2 tid=0x0000000014850800 nid=0x20e4 runnable

                         

                        "GC task thread#0 (ParallelGC)" os_prio=0 tid=0x0000000002340000 nid=0x23ec runn

                        able

                         

                        "GC task thread#1 (ParallelGC)" os_prio=0 tid=0x0000000002341800 nid=0xb7c runna

                        ble

                         

                        "GC task thread#2 (ParallelGC)" os_prio=0 tid=0x0000000002343000 nid=0x207c runn

                        able

                         

                        "GC task thread#3 (ParallelGC)" os_prio=0 tid=0x0000000002347000 nid=0xe8c runna

                        ble

                         

                        "VM Periodic Task Thread" os_prio=2 tid=0x0000000015d3e000 nid=0x23c0 waiting on

                        condition

                         

                        JNI global references: 2682

                         

                        C:\Program Files\Java\jdk1.8.0_121\bin>

                         

                        Thanks!

                        • 10. Re: Export/Browse window in SQL Developer takes a long time to come up!
                          Gary Graham-Oracle

                          Perhaps it is taking Windows longer and longer to determine if you have access?

                          "AWT-EventQueue-0" #15 prio=6 os_prio=0 tid=0x00000000167d3800 nid=0x1fdc runnable [0x000000001764c000]

                             java.lang.Thread.State: RUNNABLE

                          java.io.WinNTFileSystem.checkAccess(Native Method)

                          • 12. Re: Export/Browse window in SQL Developer takes a long time to come up!
                            Gary Graham-Oracle

                            This is just speculation, but there may be several things that might cause this, for example...

                            1. External drives / SD cards connected to your system

                            2. Accessing a folder controlled by a VCS like Subversion -- I recall past issues for that, but unsure of the current status / behavior.

                             

                            Why not do a web search on "java.io.WinNTFileSystem.checkAccess is slow /  hangs" and see if you find other such cases.

                            • 13. Re: Export/Browse window in SQL Developer takes a long time to come up!
                              Brian Jeffries-Oracle

                              Networked remote drives are particularly bad once the file / directory counts go up. For sure, its going to ask about every directory/file in the target directory and every directory on the path there before the file open/save dialog shows up. It may also be asking more about the directories on the path but I'm not sure.

                               

                              Gary's web search idea is a good one. It may turn up something we haven't thought of.

                               

                              Good luck. I wish we could point a finger and say "that", but there are too many variables without some extra digging.

                              • 14. Re: Export/Browse window in SQL Developer takes a long time to come up!
                                IckyIckyChiMoon

                                I've had the same (seemingly so) issue. Just upgraded to 4.2 and still VERY slow when using the open-file dialog. After reading some of the posts in this thread, I found a fix that worked for me.

                                 

                                I noticed that when I click on the File/Open (this is what was taking so long) there were scads of folders on the left that show up - some from remote shared file systems. I wish there were a way to remove these through the Sql-Dev interface. However, I found a file in the settings folder: "system4.2.0.17.089.1709\o.sqldeveloper.12.2.1.17.89.1709\product-preferences.xml". I edited the file and removed entries that pointed to my remote, shared, file-systems (made a back up and did this with SQL-Dev closed). Next time I opened SQL-Dev it was quick and fast, just like it used to be. Hope this helps you too.

                                 

                                For Jeff Smith -- how about a way to edit the folder list easily -- or is there one I just haven't found.

                                Other than a few issues like this, once in a while -- I like the product quite a bit. -- Thanks.

                                 

                                iicm

                                1 2 Previous Next