6 Replies Latest reply on Jun 6, 2014 8:39 AM by user8632123

    SqlDeveloper freezes

    user8632123

      Hi everyone,

       

      I noticed that my SqlDeveloper 4.0.2 "freezes" quite regularly; it simply does nothing and does not accept keyboard input or mouse clicks. It remains in that state for 20 or 30 seconds, then continues to work normally. No error message or log entry.

      It happens when connected to some database (various ones, not correlated) in either worksheet or table data view or whatever in a status, where it does nothing except wait. No query running.

       

      Where can it hang?

        • 1. Re: SqlDeveloper freezes
          thatJeffSmith-Oracle

          The next time it hangs, attach to the pid using jstack - this is a debugging tool found in your jdk/bin directory.

           

          Share that log here.

          • 2. Re: SqlDeveloper freezes
            user8632123

            Hi Jeff,

             

            it happened again. The jstack output looks as below.

             

            Bernd.

             

            2014-06-04 09:19:16

            Full thread dump Java HotSpot(TM) 64-Bit Server VM (24.55-b03 mixed mode):

             

            "RaptorTask: Object Selection" prio=6 tid=0x000000000f0df800 nid=0x1788 waiting on condition [0x0000000019fef000]

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

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

                - parking to wait for  <0x00000000cfebc950> (a java.util.concurrent.SynchronousQueue$TransferStack)

                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)

                at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)

                at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:359)

                at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:942)

                at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

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

             

            "pool-4-thread-1" prio=6 tid=0x000000000f0db000 nid=0x29a8 waiting on condition [0x000000001974f000]

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

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

                - parking to wait for  <0x00000000fe253c90> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)

                at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1090)

                at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:807)

                at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

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

             

            "Timer-3" daemon prio=6 tid=0x000000000f0dc800 nid=0x18b8 in Object.wait() [0x00000000173af000]

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

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

                - waiting on <0x00000000fdfb9100> (a java.util.TaskQueue)

                at java.util.TimerThread.mainLoop(Timer.java:552)

                - locked <0x00000000fdfb9100> (a java.util.TaskQueue)

                at java.util.TimerThread.run(Timer.java:505)

             

            "Background Parser" prio=6 tid=0x000000000f0de000 nid=0x27b0 waiting on condition [0x0000000019aef000]

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

                at java.lang.Thread.sleep(Native Method)

                at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:142)

                at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)

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

             

            "TextBufferScavenger" prio=6 tid=0x000000000f0da800 nid=0x2068 in Object.wait() [0x000000001954f000]

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

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

                - waiting on <0x00000000d2a02b70> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

                at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145)

             

            "Abandoned connection cleanup thread" daemon prio=6 tid=0x000000000f0dc000 nid=0x2ab0 in Object.wait() [0x000000001964f000]

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

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

                - waiting on <0x00000000d2ed70c0> (a java.lang.ref.ReferenceQueue$Lock)

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

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

                at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:41)

             

            "status-0" prio=2 tid=0x000000000f0d9000 nid=0x1738 waiting on condition [0x00000000175af000]

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

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

                - parking to wait for  <0x00000000d2a03b00> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

                at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)

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

                at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338)

                at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300)

                at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

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

             

            "IconOverlayTracker Timer: null-jdbcNodeInfoType" prio=6 tid=0x000000000f0d9800 nid=0xe28 in Object.wait() [0x000000001944f000]

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

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

                - waiting on <0x00000000d1ce9bb0> (a java.util.TaskQueue)

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

                at java.util.TimerThread.mainLoop(Timer.java:526)

                - locked <0x00000000d1ce9bb0> (a java.util.TaskQueue)

                at java.util.TimerThread.run(Timer.java:505)

             

            "WaitCursor-Timer" prio=6 tid=0x000000000f0d8000 nid=0x15e0 in Object.wait() [0x00000000170af000]

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

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

                - waiting on <0x00000000d27cfeb0> (a java.util.TaskQueue)

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

                at java.util.TimerThread.mainLoop(Timer.java:526)

                - locked <0x00000000d27cfeb0> (a java.util.TaskQueue)

                at java.util.TimerThread.run(Timer.java:505)

             

            "WeakDataReference polling" prio=2 tid=0x000000000f0d7800 nid=0x18d4 in Object.wait() [0x0000000016faf000]

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

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

                - waiting on <0x00000000d123f918> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

                at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)

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

             

            "Thread-11" daemon prio=6 tid=0x000000000f0d4800 nid=0x1770 in Object.wait() [0x00000000174af000]

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

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

                - waiting on <0x00000000cf659248> (a java.util.LinkedList)

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

                at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1476)

                - locked <0x00000000cf659248> (a java.util.LinkedList)

             

            "Thread-10" daemon prio=6 tid=0x000000000f0d3800 nid=0x13b0 runnable [0x0000000016a6f000]

               java.lang.Thread.State: RUNNABLE

                at sun.print.Win32PrintServiceLookup.notifyPrinterChange(Native Method)

                at sun.print.Win32PrintServiceLookup.access$100(Win32PrintServiceLookup.java:50)

                at sun.print.Win32PrintServiceLookup$PrinterChangeListener.run(Win32PrintServiceLookup.java:323)

             

            "ChangeSetService" daemon prio=2 tid=0x000000000f0d2000 nid=0x1130 in Object.wait() [0x0000000016baf000]

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

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

                - waiting on <0x00000000d035c5d0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)

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

                at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:131)

                - locked <0x00000000d035c5d0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)

                at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:152)

                at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$000(ChangeSetService.java:60)

                at oracle.jdevimpl.vcs.changeset.ChangeSetService$1.run(ChangeSetService.java:99)

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

             

            "Thread-9" daemon prio=6 tid=0x000000000f0d1800 nid=0x27a8 in Object.wait() [0x000000001696f000]

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

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

                - waiting on <0x00000000d0d1f508> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

                at org.tmatesoft.svn.core.javahl.SVNClientImplTracker.run(SVNClientImplTracker.java:65)

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

             

            "Keep-Alive-Timer" daemon prio=8 tid=0x000000000d237000 nid=0x2258 waiting on condition [0x000000001592f000]

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

                at java.lang.Thread.sleep(Native Method)

                at sun.net.www.http.KeepAliveCache.run(KeepAliveCache.java:172)

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

             

            "RaptorTask: Usage Data" prio=6 tid=0x000000000d236000 nid=0x2138 waiting on condition [0x0000000015c1f000]

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

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

                - parking to wait for  <0x00000000cfebc950> (a java.util.concurrent.SynchronousQueue$TransferStack)

                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)

                at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)

                at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:359)

                at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:942)

                at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

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

             

            "Scheduler" daemon prio=6 tid=0x000000000d235800 nid=0x24d4 in Object.wait() [0x0000000015b1f000]

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

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

                - waiting on <0x00000000cfed3a40> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)

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

                at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)

                - locked <0x00000000cfed3a40> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)

                at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:479)

             

            "Log Poller" prio=2 tid=0x000000000d234800 nid=0x291c waiting on condition [0x000000001485f000]

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

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

                - parking to wait for  <0x00000000cff0ad98> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

                at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)

                at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)

                at oracle.ide.log.QueuedLoggingHandler.take(QueuedLoggingHandler.java:60)

                at oracle.ideimpl.log.TabbedLogManager$4.run(TabbedLogManager.java:321)

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

             

            "Inactive RequestProcessor thread [Was:TimedSoftReference/org.openide.util.TimedSoftReference]" daemon prio=2 tid=0x000000000d234000 nid=0x27e8 in Object.wait() [0x000000001475f000]

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

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

                - waiting on <0x00000000cf28f508> (a java.lang.Object)

                at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1989)

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

             

            "JarIndex Timer" daemon prio=6 tid=0x000000000d233000 nid=0x474 in Object.wait() [0x000000001465f000]

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

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

                - waiting on <0x00000000cf413680> (a java.util.TaskQueue)

                at java.util.TimerThread.mainLoop(Timer.java:552)

                - locked <0x00000000cf413680> (a java.util.TaskQueue)

                at java.util.TimerThread.run(Timer.java:505)

             

            "Inactive RequestProcessor thread [Was:Folder recognizer/org.openide.loaders.FolderList$ListTask]" daemon prio=6 tid=0x000000000d232800 nid=0x1ac4 in Object.wait() [0x000000001455f000]

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

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

                - waiting on <0x00000000cf1ce5b8> (a java.lang.Object)

                at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1989)

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

             

            "TimedCache-Timer" daemon prio=6 tid=0x000000000d231000 nid=0x2ba4 in Object.wait() [0x000000000edbf000]

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

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

                - waiting on <0x00000000cfd5f200> (a java.util.TaskQueue)

                at java.util.TimerThread.mainLoop(Timer.java:552)

                - locked <0x00000000cfd5f200> (a java.util.TaskQueue)

                at java.util.TimerThread.run(Timer.java:505)

             

            "Framework Event Dispatcher" daemon prio=6 tid=0x000000000d230000 nid=0x2628 in Object.wait() [0x000000000ebbf000]

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

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

                - waiting on <0x00000000ce711178> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

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

                at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)

                - locked <0x00000000ce711178> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

                at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:336)

             

            "State Data Manager" daemon prio=6 tid=0x000000000d45a000 nid=0x2604 waiting on condition [0x000000000eabf000]

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

                at java.lang.Thread.sleep(Native Method)

                at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.java:297)

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

             

            "Framework Active Thread" prio=6 tid=0x000000000f03b000 nid=0x158c in Object.wait() [0x000000000e84f000]

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

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

                - waiting on <0x00000000cf6c95d0> (a org.eclipse.osgi.framework.internal.core.Framework)

                at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java:1863)

                - locked <0x00000000cf6c95d0> (a org.eclipse.osgi.framework.internal.core.Framework)

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

             

            "Inactive RequestProcessor thread [Was:Folder recognizer/org.openide.loaders.FolderList$ListTask]" daemon prio=2 tid=0x000000000d179800 nid=0x2208 in Object.wait() [0x000000000e3df000]

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

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

                - waiting on <0x00000000ce2d24d0> (a java.lang.Object)

                at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1989)

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

             

            "Active Reference Queue Daemon" daemon prio=2 tid=0x000000000d0fd800 nid=0x1ce8 in Object.wait() [0x000000000e02f000]

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

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

                - waiting on <0x00000000cf762270> (a java.lang.ref.ReferenceQueue$Lock)

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

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

                at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.java:180)

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

             

            "TimerQueue" daemon prio=6 tid=0x000000000a144800 nid=0x27a4 waiting on condition [0x000000000d86f000]

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

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

                - parking to wait for  <0x00000000ceb467b0> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)

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

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

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

             

            "AWT-EventQueue-0" prio=6 tid=0x000000000a13e800 nid=0x24f4 runnable [0x000000000bdce000]

               java.lang.Thread.State: RUNNABLE

                at sun.awt.Win32GraphicsDevice.isPixFmtSupported(Native Method)

                at sun.awt.Win32GraphicsDevice.getConfigurations(Win32GraphicsDevice.java:184)

                at javax.swing.ToolTipManager.getDrawingGC(ToolTipManager.java:227)

                at javax.swing.ToolTipManager.showTipWindow(ToolTipManager.java:263)

                at javax.swing.ToolTipManager$insideTimerAction.actionPerformed(ToolTipManager.java:669)

                at javax.swing.Timer.fireActionPerformed(Timer.java:312)

                at javax.swing.Timer$DoPostEvent.run(Timer.java:244)

                at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)

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

                at java.awt.EventQueue.access$200(EventQueue.java:103)

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

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

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

                at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

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

                at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

                at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

                at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

                at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

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

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

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

             

            "AWT-Windows" daemon prio=6 tid=0x000000000a13d800 nid=0x1dbc runnable [0x000000000bbcf000]

               java.lang.Thread.State: RUNNABLE

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

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

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

             

            "AWT-Shutdown" prio=6 tid=0x000000000a14b800 nid=0x108c in Object.wait() [0x000000000bacf000]

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

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

                - waiting on <0x00000000ce2904c0> (a java.lang.Object)

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

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

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

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

             

            "Java2D Disposer" daemon prio=10 tid=0x000000000a14a800 nid=0x1e98 in Object.wait() [0x000000000b9cf000]

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

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

                - waiting on <0x00000000ceac4448> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

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

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

             

            "Service Thread" daemon prio=6 tid=0x0000000008e2e800 nid=0x2070 runnable [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "C2 CompilerThread1" daemon prio=10 tid=0x0000000008e27800 nid=0x2b5c waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "C2 CompilerThread0" daemon prio=10 tid=0x0000000008e22000 nid=0x1f80 waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "Attach Listener" daemon prio=10 tid=0x0000000008e21000 nid=0xc58 waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "Signal Dispatcher" daemon prio=10 tid=0x0000000008e20000 nid=0x2848 runnable [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "Finalizer" daemon prio=8 tid=0x0000000008e16000 nid=0x1df0 in Object.wait() [0x000000000b1df000]

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

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

                - waiting on <0x00000000ce99a550> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

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

             

            "Reference Handler" daemon prio=10 tid=0x0000000008e0d800 nid=0x2564 in Object.wait() [0x000000000b0df000]

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

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

                - waiting on <0x00000000ce64d070> (a java.lang.ref.Reference$Lock)

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

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

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

             

            "main" prio=6 tid=0x0000000002a3b800 nid=0x14b8 waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "VM Thread" prio=10 tid=0x0000000009f92800 nid=0x1904 runnable

             

            "GC task thread#0 (ParallelGC)" prio=6 tid=0x0000000002a50000 nid=0x3fc runnable

             

            "GC task thread#1 (ParallelGC)" prio=6 tid=0x0000000002a53000 nid=0x1f04 runnable

             

            "GC task thread#2 (ParallelGC)" prio=6 tid=0x0000000002a54800 nid=0x2410 runnable

             

            "GC task thread#3 (ParallelGC)" prio=6 tid=0x0000000002a56000 nid=0x18c0 runnable

             

            "GC task thread#4 (ParallelGC)" prio=6 tid=0x0000000002a5a800 nid=0x20d0 runnable

             

            "GC task thread#5 (ParallelGC)" prio=6 tid=0x0000000002a5b800 nid=0x1610 runnable

             

            "GC task thread#6 (ParallelGC)" prio=6 tid=0x0000000002a5d000 nid=0x1a8c runnable

             

            "GC task thread#7 (ParallelGC)" prio=6 tid=0x0000000002a5e000 nid=0x10fc runnable

             

            "VM Periodic Task Thread" prio=10 tid=0x0000000009ff9000 nid=0x1bb8 waiting on condition

             

            JNI global references: 3675

            • 3. Re: SqlDeveloper freezes
              thatJeffSmith-Oracle

              the OS wants to draw something, that's where the hang is occurring

               

              What version of Windows and what version of the JDK are you running?

              • 4. Re: SqlDeveloper freezes
                Gary Graham-Oracle

                Searching for isPixFmtSupported, this appears to be an old Java bug, mostly fixed on platforms other than Windows, but still open and recently having had its priority bumped up:  Bug ID: JDK-6477756 GraphicsDevice.getConfigurations() is slow taking 3 or more seconds

                 

                Netbeans users have also long complained about this bug, as in https://netbeans.org/bugzilla/show_bug.cgi?id=227232.  One user said that updating his NVIDIA video driver got rid of the performance hit.  The recommended workaround from the Java Bug DB -- set this property:

                -Dsun.awt.nopixfmt=true

                either on the command line or with an AddVMOption line in the sqldeveloper.conf file.  However, note that

                some applications which use OpenGL with Java may not work correctly

                Regards,
                Gary

                SQL Developer Team 

                • 5. Re: SqlDeveloper freezes
                  user8632123

                  Hi Jeff and Gary,

                   

                  I am using Windows 7 and JDK 1.7.0_55, the one that comes with SqlDeveloper.

                   

                  I am trying the "-Dsun.awt.nopixfmt=true" workaround now.

                   

                  Thnaks,

                   

                  Bernd.

                  • 6. Re: SqlDeveloper freezes
                    user8632123

                    Using the parameter "-Dsun.awt.nopixfmt=true" seems to have solved the problem.