8 Replies Latest reply on Oct 2, 2015 9:02 AM by Konstantinos Tsividis

    Oracle SQL Developer issue

    Konstantinos Tsividis

      Hello

      The problem is that when i am running "heavy" queries through SQL Developer (v. 4.1.1.19 or back) the IDE does not respond at any other action while the query (queries) is running (i cannot cancel the task). I mean if want to connect to an other schema or choose any option from the menu of the IDE then i have to open a second SQL Developer window. Why is that so... Is it something that i do wrong?

        • 1. Re: Oracle SQL Developer issue
          thatJeffSmith-Oracle

          Something is less than right. While a query is running, the GUI should be responsive. You should be able to open the View > Task Progress panel, open a new connection, and request to cancel your query.

           

          When it becomes unresponsive, get a stack dump and send it here. That might give us a clue as to what's wrong.

          • 2. Re: Oracle SQL Developer issue
            Konstantinos Tsividis

            Ok i did again... Query was not gining results, i canceled it but on the Task progres was still running so neither i could open an new sql window of the same connection nor i could end the connection... On the Task Progress Panel i just opened 2 more tasks waiting. Ok i did

            what you' re saying in "stack  dump" link and i got this:

            ----------------------------------------------------------------------------------

                - parking to wait for  <0x00000000d28e1350> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                at java.util.concurrent.DelayQueue.take(DelayQueue.java:211)
                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:1067)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                at java.lang.Thread.run(Thread.java:745)

             

            "WeakDataReference polling" #74 prio=1 os_prio=-2 tid=0x000000001c99e800 nid=0xe08 in Object.wait() [0x00000000186bf000]

               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 <0x00000000d29265a0> (a java.lang.ref.ReferenceQueue$Lock)
                at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)
                at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)
                at java.lang.Thread.run(Thread.java:745)

             

            "Background Parser" #70 prio=6 os_prio=0 tid=0x000000001c99d800 nid=0x1b50 waiting on condition [0x000000001ee6f000]

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

                at java.lang.Thread.sleep(Native Method)
                at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:126)
                at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
                at java.lang.Thread.run(Thread.java:745)

             

            "TextBufferScavenger" #68 prio=6 os_prio=0 tid=0x000000001c9a0000 nid=0x1110 in Object.wait() [0x000000001e1df000]

               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 <0x00000000d15696a8> (a java.lang.ref.ReferenceQueue$Lock)
                at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)
                at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145)

             

            "oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser" #64 daemon prio=4 os_prio=-1 tid=0x000000001fa39800 nid=0x148c in Object.wait() [0x00000000174df000]

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

                at java.lang.Object.wait(Native Method)
                at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:327)
                - locked <0x00000000d15d0238> (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)

             

            "WaitCursor-Timer" #50 prio=6 os_prio=0 tid=0x000000001fa34800 nid=0x1ff4 in Object.wait() [0x000000002649f000]

               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.util.TimerThread.mainLoop(Timer.java:526)
                - locked <0x00000000d1473900> (a java.util.TaskQueue)
                at java.util.TimerThread.run(Timer.java:505)

             

            "IconOverlayTracker Timer: null-jdbcNodeInfoType" #47 prio=5 os_prio=0 tid=0x000000001fa3a800 nid=0xcf4 in Object.wait() [0x000000002629f000]

               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.util.TimerThread.mainLoop(Timer.java:526)
                - locked <0x00000000d1365760> (a java.util.TaskQueue)
                at java.util.TimerThread.run(Timer.java:505)

             

            "Thread-10" #43 daemon prio=5 os_prio=0 tid=0x000000001fa33000 nid=0x1a28 in Object.wait() [0x0000000023fff000]

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

                at java.lang.Object.wait(Native Method)
                - waiting on <0x00000000ce47bcb8> (a java.util.LinkedList)
                at java.lang.Object.wait(Object.java:502)
                at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1482)
                - locked <0x00000000ce47bcb8> (a java.util.LinkedList)

             

            "ChangeSetService" #40 daemon prio=1 os_prio=-2 tid=0x000000001fa30000 nid=0xbec in Object.wait() [0x00000000238ff000]

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

                at java.lang.Object.wait(Native Method)
                - waiting on <0x00000000d103a4f8> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
                at java.lang.Object.wait(Object.java:502)
                at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:131)
                - locked <0x00000000d103a4f8> (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)

             

            "Raptor Metrics Engine Thread" #39 daemon prio=5 os_prio=0 tid=0x000000001fa32000 nid=0x10bc waiting on condition [0x000000002244f000]

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

                at sun.misc.Unsafe.park(Native Method)
                - parking to wait for  <0x00000000cff87d40> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1081)
                at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
                at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                at java.lang.Thread.run(Thread.java:745)

             

            "Scheduler" #38 daemon prio=5 os_prio=0 tid=0x000000001fa2c000 nid=0x1354 in Object.wait() [0x00000000220df000]

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

                at java.lang.Object.wait(Native Method)
                at java.lang.Object.wait(Object.java:502)
                at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)
                - locked <0x00000000cff8c318> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
                at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:537)

             

            "Log Poller" #37 prio=1 os_prio=-2 tid=0x000000001fa2d800 nid=0xb00 waiting on condition [0x000000002279f000]

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

                at sun.misc.Unsafe.park(Native Method)
                - parking to wait for  <0x00000000cfa7fd20> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                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:333)
                at java.lang.Thread.run(Thread.java:745)

             

            "TimedCache-Timer" #31 daemon prio=5 os_prio=0 tid=0x000000001c99f000 nid=0xd7c in Object.wait() [0x000000001e91f000]

               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.util.TimerThread.mainLoop(Timer.java:526)
                - locked <0x00000000cefc1980> (a java.util.TaskQueue)
                at java.util.TimerThread.run(Timer.java:505)

             

            "Framework Event Dispatcher" #27 daemon prio=5 os_prio=0 tid=0x000000001c9a2000 nid=0x110c in Object.wait() [0x000000001e81f000]

               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.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)
                - locked <0x00000000ce57fe58> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)
                at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:336)

             

            "State Data Manager" #23 daemon prio=5 os_prio=0 tid=0x000000001d3aa800 nid=0x18ec waiting on condition [0x000000001dfdf000]

               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" #22 prio=5 os_prio=0 tid=0x0000000016913000 nid=0x1858 in Object.wait() [0x000000001dedf000]

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

                at java.lang.Object.wait(Native Method)
                at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java:1862)
                - locked <0x00000000ce538940> (a org.eclipse.osgi.framework.internal.core.Framework)
                at java.lang.Thread.run(Thread.java:745)

             

            "Active Reference Queue Daemon" #18 daemon prio=1 os_prio=-2 tid=0x0000000016605000 nid=0x125c in Object.wait() [0x0000000017dcf000]

               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.java:57)
                at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.java:180)
                - locked <0x00000000ce528c50> (a java.lang.ref.ReferenceQueue$Lock)

             

            "TimerQueue" #16 daemon prio=5 os_prio=0 tid=0x0000000016433800 nid=0x1ddc runnable [0x00000000179cf000]

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

                at sun.misc.Unsafe.park(Native Method)
                - parking to wait for  <0x00000000ce15f7b8> (a java.util.concurrent.locks.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:171)
                at java.lang.Thread.run(Thread.java:745)

             

            "AWT-EventQueue-0" #15 prio=6 os_prio=0 tid=0x00000000163c7800 nid=0x16fc waiting on condition [0x00000000170df000]

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

                at sun.misc.Unsafe.park(Native Method)
                - parking to wait for  <0x00000000ce4cf940> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                at java.awt.EventQueue.getNextEvent(EventQueue.java:554)
                at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:170)
                at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)

             

            "AWT-Windows" #13 daemon prio=6 os_prio=0 tid=0x00000000163c0000 nid=0x1608 runnable [0x0000000016ebf000]

               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)

             

            "AWT-Shutdown" #12 prio=5 os_prio=0 tid=0x00000000163bd800 nid=0x1894 in Object.wait() [0x0000000016cbf000]

               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 <0x00000000ce14fa40> (a java.lang.Object)
                at java.lang.Thread.run(Thread.java:745)

             

            "Java2D Disposer" #11 daemon prio=10 os_prio=2 tid=0x00000000163bd000 nid=0x1ed0 in Object.wait() [0x0000000016bbf000]

               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 <0x00000000ce4baf70> (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)

             

            "Service Thread" #9 daemon prio=9 os_prio=0 tid=0x0000000015c05000 nid=0x13a4 runnable [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "C1 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x000000001438e000 nid=0x1428 waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x0000000014388800 nid=0x1ffc waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x0000000014385800 nid=0x14cc waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x0000000014383000 nid=0x1a64 runnable [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x0000000014382000 nid=0x5e8 waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x000000000247d800 nid=0x1bd0 in Object.wait() [0x00000000156df000]

               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 <0x00000000ce1805a8> (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)

             

            "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000002475000 nid=0x1e64 in Object.wait() [0x00000000155df000]

               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$ReferenceHandler.run(Reference.java:157)
                - locked <0x00000000ce15e7b0> (a java.lang.ref.Reference$Lock)

             

            "main" #1 prio=5 os_prio=0 tid=0x0000000002384800 nid=0x5b8 waiting on condition [0x0000000000000000]

               java.lang.Thread.State: RUNNABLE

             

            "VM Thread" os_prio=2 tid=0x0000000014349000 nid=0x8e0 runnable

             

            "GC task thread#0 (ParallelGC)" os_prio=0 tid=0x000000000239a000 nid=0x1cf8 runnable

             

            "GC task thread#1 (ParallelGC)" os_prio=0 tid=0x000000000239b800 nid=0xdf0 runnable

             

            "GC task thread#2 (ParallelGC)" os_prio=0 tid=0x000000000239d800 nid=0x1b58 runnable

             

            "GC task thread#3 (ParallelGC)" os_prio=0 tid=0x000000000239f000 nid=0x112c runnable

             

            "VM Periodic Task Thread" os_prio=2 tid=0x0000000015c07800 nid=0x568 waiting on condition

             

            JNI global references: 3156

             

            Heap

            PSYoungGen  total 227328K, used 128166K [0x00000000ef580000, 0x00000000fe680000, 0x0000000100000000)

              eden space 208896K, 58% used [0x00000000ef580000,0x00000000f6cfee70,0x00000000fc180000)

              from space 18432K, 31% used [0x00000000fd480000,0x00000000fda2aaa0,0x00000000fe680000)

              to   space 18944K, 0% used [0x00000000fc180000,0x00000000fc180000,0x00000000fd400000)

            ParOldGen   total 302080K, used 95180K [0x00000000ce000000, 0x00000000e0700000, 0x00000000ef580000)

              object space 302080K, 31% used [0x00000000ce000000,0x00000000d3cf3320,0x00000000e0700000)

            Metaspace   used 101891K, capacity 109308K, committed 109528K, reserved 1142784K
              class spaceused 12964K, capacity 15289K, committed 15360K, reserved 1048576K
            • 3. Re: Oracle SQL Developer issue
              Gary Graham-Oracle

              That is a partial thread dump.  You must not have set the buffer size large enough in the console window from which SQL Developer got launched.  Either increase the buffer size and repeat, or you can always use jstack to get the dump...

              1. Open another console window

              2. Use <java_bin_dir>\jps -l to find the process id (PID) of oracle.ide.osgi.boot.OracleIdeLauncher

              3. Use <java_bin_dir>\jstack PID to get the full thread dump

              4. To avoid line wrap issues in a narrow console window, you can always redirect the jstack to a file, as in jstack PID > mydump.log

              The full thread dump begins with a time stamp followed by a line beginning in Full thread dump Java HotSpot(TM)...

              • 4. Re: Oracle SQL Developer issue
                Konstantinos Tsividis

                Using the last you wtote me (jps -l, jstack e.t.c.)

                I got the following. I also mention that jdk is "jdk1.8.0_31" on windows 10 64bit.

                 

                "WeakDataReference polling" #67 prio=1 os_prio=-2 tid=0x000000001fb1a800 nid=0x1988 in Object.wait() [0x000000002444f000]

                   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 <0x00000000d2a16f38> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

                 

                "Background Parser" #62 prio=6 os_prio=0 tid=0x000000001cbea000 nid=0x1e68 waiting on condition [0x000000002768f000]

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

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

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

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

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

                 

                "TextBufferScavenger" #60 prio=6 os_prio=0 tid=0x000000001e136800 nid=0xdcc in Object.wait() [0x00000000239cf000]

                   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 <0x00000000d14cd308> (a java.lang.ref.ReferenceQueue$Lock)

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

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

                 

                "RaptorTask: Usage Data" #59 prio=5 os_prio=0 tid=0x000000001e135000 nid=0x1e08 runnable [0x000000002142e000]

                   java.lang.Thread.State: RUNNABLE

                        at java.net.SocketInputStream.socketRead0(Native Method)

                        at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)

                        at java.net.SocketInputStream.read(SocketInputStream.java:170)

                        at java.net.SocketInputStream.read(SocketInputStream.java:141)

                        at oracle.net.ns.Packet.receive(Packet.java:311)

                        at oracle.net.ns.DataPacket.receive(DataPacket.java:105)

                        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)

                        at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)

                        at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)

                        at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)

                        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)

                        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)

                        at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)

                        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)

                        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

                        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

                        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

                        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)

                        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)

                        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:926)

                        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1112)

                        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)

                        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4846)

                        - locked <0x00000000d100f9f8> (a oracle.jdbc.driver.T4CConnection)

                        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)

                        at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)

                        at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:486)

                        at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:267)

                        at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:682)

                        at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:666)

                        at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

                        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)

                        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

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

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

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

                 

                "oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser" #56 daemon prio=4 os_prio=-1 tid=0x000000001e134000 nid=0x5fc in Object.wait() [0x000000002132f000]

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

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

                        at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:327)

                        - locked <0x00000000d14fc280> (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)

                 

                "WaitCursor-Timer" #51 prio=6 os_prio=0 tid=0x000000001e133800 nid=0x1934 in Object.wait() [0x000000002718f000]

                   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.util.TimerThread.mainLoop(Timer.java:526)

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

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

                 

                "IconOverlayTracker Timer: null-jdbcNodeInfoType" #48 prio=5 os_prio=0 tid=0x000000001e12f800 nid=0x1d88 in Object.wait() [0x0000000026e8f000]

                   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.util.TimerThread.mainLoop(Timer.java:526)

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

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

                 

                "Thread-10" #43 daemon prio=5 os_prio=0 tid=0x000000001e12a800 nid=0x3bc in Object.wait() [0x0000000023f3f000]

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

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

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

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

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

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

                 

                "ChangeSetService" #40 daemon prio=1 os_prio=-2 tid=0x000000001e129000 nid=0x1088 in Object.wait() [0x000000002302f000]

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

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

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

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

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

                        - locked <0x00000000d115ded0> (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)

                 

                "Raptor Metrics Engine Thread" #39 daemon prio=5 os_prio=0 tid=0x000000001e127800 nid=0x1a50 waiting on condition [0x0000000022aff000]

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

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

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

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

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

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

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

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

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

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

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

                 

                "Scheduler" #38 daemon prio=5 os_prio=0 tid=0x000000001e12c000 nid=0x154c in Object.wait() [0x00000000234cf000]

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

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

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

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

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

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

                 

                "Log Poller" #37 prio=1 os_prio=-2 tid=0x000000001e12e000 nid=0x1394 waiting on condition [0x00000000231cf000]

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

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

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

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

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

                        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:333)

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

                 

                "TimedCache-Timer" #31 daemon prio=5 os_prio=0 tid=0x000000001cbeb800 nid=0x1d64 in Object.wait() [0x000000001f47f000]

                   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.util.TimerThread.mainLoop(Timer.java:526)

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

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

                 

                "Framework Event Dispatcher" #26 daemon prio=5 os_prio=0 tid=0x000000001cbef800 nid=0x1e30 in Object.wait() [0x000000001ed6f000]

                   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.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)

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

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

                 

                "State Data Manager" #23 daemon prio=5 os_prio=0 tid=0x000000001d595000 nid=0x1390 waiting on condition [0x000000001e73f000]

                   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" #22 prio=5 os_prio=0 tid=0x000000001cef3800 nid=0x116c in Object.wait() [0x000000001ea6f000]

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

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

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

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

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

                 

                "Active Reference Queue Daemon" #18 daemon prio=1 os_prio=-2 tid=0x0000000016662000 nid=0x1b60 in Object.wait() [0x0000000017daf000]

                   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.java:57)

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

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

                 

                "TimerQueue" #16 daemon prio=5 os_prio=0 tid=0x00000000164ae000 nid=0x1444 waiting on condition [0x00000000179af000]

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

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

                        - parking to wait for  <0x00000000ce14c050> (a java.util.concurrent.locks.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:171)

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

                 

                "AWT-EventQueue-0" #15 prio=6 os_prio=0 tid=0x000000001642f800 nid=0x4a0 waiting on condition [0x000000001702f000]

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

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

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

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

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

                        at java.awt.EventQueue.getNextEvent(EventQueue.java:554)

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

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

                        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)

                 

                "AWT-Windows" #13 daemon prio=6 os_prio=0 tid=0x0000000016429800 nid=0xa40 runnable [0x0000000016f2f000]

                   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)

                 

                "AWT-Shutdown" #12 prio=5 os_prio=0 tid=0x0000000016424800 nid=0xd80 in Object.wait() [0x0000000016d2f000]

                   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 <0x00000000ce14c470> (a java.lang.Object)

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

                 

                "Java2D Disposer" #11 daemon prio=10 os_prio=2 tid=0x0000000016424000 nid=0xd44 in Object.wait() [0x0000000016c2f000]

                   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 <0x00000000ce81a490> (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)

                 

                "Service Thread" #9 daemon prio=9 os_prio=0 tid=0x0000000015c78800 nid=0x1c1c runnable [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "C1 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x000000001440c000 nid=0x1e44 waiting on condition [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x0000000014408800 nid=0x1084 waiting on condition [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x0000000014405800 nid=0x164 waiting on condition [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x0000000014403000 nid=0x1864 waiting on condition [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x0000000014402000 nid=0x17a4 runnable [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x000000000249d800 nid=0x1a9c in Object.wait() [0x000000001574f000]

                   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 <0x00000000ce4d8410> (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)

                 

                "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000002495000 nid=0x1900 in Object.wait() [0x000000001564f000]

                   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$ReferenceHandler.run(Reference.java:157)

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

                 

                "main" #1 prio=5 os_prio=0 tid=0x00000000023a4800 nid=0x1284 waiting on condition [0x0000000000000000]

                   java.lang.Thread.State: RUNNABLE

                 

                "VM Thread" os_prio=2 tid=0x00000000143c8000 nid=0xda4 runnable

                 

                "GC task thread#0 (ParallelGC)" os_prio=0 tid=0x00000000023ba000 nid=0x954 runnable

                 

                "GC task thread#1 (ParallelGC)" os_prio=0 tid=0x00000000023bb800 nid=0xa48 runnable

                 

                "GC task thread#2 (ParallelGC)" os_prio=0 tid=0x00000000023bd800 nid=0x1450 runnable

                 

                "GC task thread#3 (ParallelGC)" os_prio=0 tid=0x00000000023bf000 nid=0x1fa0 runnable

                 

                "VM Periodic Task Thread" os_prio=2 tid=0x0000000015c7b000 nid=0x57c waiting on condition

                 

                JNI global references: 1924

                 

                 

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

                • 5. Re: Oracle SQL Developer issue
                  Konstantinos Tsividis

                  I am really sorry i didnt pay attention to your last line about full thread dump

                  I think know i got it...

                  ------------------------------------------------------------------------------------------------------------

                  2015-10-01 12:22:32

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

                   

                  "Inactive RequestProcessor thread [Was:TimedSoftReference/org.openide.util.TimedSoftReference]" #90 daemon prio=1 os_prio=-2 tid=0x0000000016749800 nid=0x3a4 in Object.wait() [0x0000000018caf000]

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

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

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

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

                   

                  "AliveLockThread.euro@db" #83 prio=5 os_prio=0 tid=0x0000000022f3d800 nid=0x7e4 waiting for monitor entry [0x00000000185af000]

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

                      at oracle.jdbc.driver.T4CConnection.doPingDatabase(T4CConnection.java:5216)

                      - waiting to lock <0x00000000d1235b28> (a oracle.jdbc.driver.T4CConnection)

                      at oracle.jdbc.driver.PhysicalConnection.pingDatabase(PhysicalConnection.java:7003)

                      at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCConnection$2oracle$1jdbc$1internal$1OracleConnection$$$Proxy.pingDatabase(Unknown Source)

                      at oracle.javatools.db.ora.BaseOracleDatabase.isConnectionAliveImpl(BaseOracleDatabase.java:170)

                      at oracle.javatools.db.AbstractDatabase$1.run(AbstractDatabase.java:461)

                      - locked <0x00000000d1233b88> (a oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCConnection$2oracle$1jdbc$1internal$1OracleConnection$$$Proxy)

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

                   

                  "Opening SQL Worksheet" #82 prio=5 os_prio=0 tid=0x0000000022f43800 nid=0x14d8 waiting on condition [0x00000000184af000]

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

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

                      - parking to wait for  <0x00000000fbd2b2e0> (a oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask)

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

                      at java.util.concurrent.FutureTask.awaitDone(FutureTask.java:429)

                      at java.util.concurrent.FutureTask.get(FutureTask.java:191)

                      at oracle.dbtools.raptor.tasks.IdeTaskTracker.run(IdeTaskTracker.java:64)

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

                   

                  "pool-4-thread-1" #79 prio=5 os_prio=0 tid=0x0000000022f41000 nid=0x117c waiting on condition [0x00000000173ff000]

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

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

                      - parking to wait for  <0x00000000fbdceda0> (a java.util.concurrent.locks.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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)

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

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

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

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

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

                   

                  "Image Animator 1" #76 daemon prio=3 os_prio=-1 tid=0x000000001674b000 nid=0x1504 waiting on condition [0x00000000180ef000]

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

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

                      at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:670)

                      at sun.awt.image.GifImageDecoder.readImage(GifImageDecoder.java:458)

                      at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:212)

                      at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:269)

                      at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:205)

                      at sun.awt.image.ImageFetcher.run(ImageFetcher.java:169)

                   

                  "status-0" #71 prio=2 os_prio=-2 tid=0x000000001674a000 nid=0x151c waiting on condition [0x000000000045f000]

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

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

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

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

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

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

                      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:1067)

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

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

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

                   

                  "WeakDataReference polling" #70 prio=1 os_prio=-2 tid=0x000000001674c800 nid=0xc9c in Object.wait() [0x0000000017eef000]

                     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 <0x00000000d2c0ff50> (a java.lang.ref.ReferenceQueue$Lock)

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

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

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

                   

                  "Background Parser" #65 prio=6 os_prio=0 tid=0x0000000022f39800 nid=0x1f7c waiting on condition [0x0000000021b4f000]

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

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

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

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

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

                   

                  "TextBufferScavenger" #63 prio=6 os_prio=0 tid=0x0000000022f3e000 nid=0x16cc in Object.wait() [0x000000001bf4f000]

                     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 <0x00000000d14d03b0> (a java.lang.ref.ReferenceQueue$Lock)

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

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

                   

                  "RaptorTask: Usage Data" #62 prio=5 os_prio=0 tid=0x0000000022f3b000 nid=0xf18 waiting on condition [0x0000000001dbe000]

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

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

                      - parking to wait for  <0x00000000d2821810> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

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

                      at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireNanos(AbstractQueuedSynchronizer.java:934)

                      at java.util.concurrent.locks.AbstractQueuedSynchronizer.tryAcquireNanos(AbstractQueuedSynchronizer.java:1247)

                      at java.util.concurrent.locks.ReentrantLock.tryLock(ReentrantLock.java:442)

                      at oracle.dbtools.raptor.utils.Connections.lock(Connections.java:1915)

                      at oracle.dbtools.raptor.utils.Connections.lock(Connections.java:1861)

                      at oracle.dbtools.raptor.utils.Connections.lock(Connections.java:1848)

                      at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.open(OpenWorksheetWizard.java:450)

                      at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.access$600(OpenWorksheetWizard.java:72)

                      at oracle.dbtools.worksheet.editor.OpenWorksheetWizard$1.doWork(OpenWorksheetWizard.java:415)

                      at oracle.dbtools.worksheet.editor.OpenWorksheetWizard$1.doWork(OpenWorksheetWizard.java:410)

                      at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

                      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                      at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)

                      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

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

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

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

                   

                  "oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser" #59 daemon prio=4 os_prio=-1 tid=0x0000000022f3c800 nid=0xdd8 in Object.wait() [0x000000000055f000]

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

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

                      at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:327)

                      - locked <0x00000000d162ea00> (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)

                   

                  "WaitCursor-Timer" #50 prio=6 os_prio=0 tid=0x0000000022f36800 nid=0x2cc in Object.wait() [0x0000000027c9f000]

                     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.util.TimerThread.mainLoop(Timer.java:526)

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

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

                   

                  "IconOverlayTracker Timer: null-jdbcNodeInfoType" #47 prio=5 os_prio=0 tid=0x0000000022f36000 nid=0x1e48 in Object.wait() [0x0000000027a9f000]

                     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.util.TimerThread.mainLoop(Timer.java:526)

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

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

                   

                  "pool-2-thread-1" #45 prio=5 os_prio=0 tid=0x0000000022f3a800 nid=0x1a84 runnable [0x00000000262be000]

                     java.lang.Thread.State: RUNNABLE

                      at java.net.SocketInputStream.socketRead0(Native Method)

                      at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)

                      at java.net.SocketInputStream.read(SocketInputStream.java:170)

                      at java.net.SocketInputStream.read(SocketInputStream.java:141)

                      at oracle.net.ns.Packet.receive(Packet.java:311)

                      at oracle.net.ns.DataPacket.receive(DataPacket.java:105)

                      at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)

                      at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)

                      at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)

                      at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)

                      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)

                      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

                      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

                      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

                      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)

                      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)

                      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:926)

                      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1112)

                      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)

                      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4846)

                      - locked <0x00000000d1235b28> (a oracle.jdbc.driver.T4CConnection)

                      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)

                      at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)

                      at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:486)

                      at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:267)

                      at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:682)

                      at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:666)

                      at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

                      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                      at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)

                      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

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

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

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

                   

                  "Thread-10" #43 daemon prio=5 os_prio=0 tid=0x0000000022f38000 nid=0x3bc in Object.wait() [0x00000000267bf000]

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

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

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

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

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

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

                   

                  "ChangeSetService" #40 daemon prio=1 os_prio=-2 tid=0x0000000022f39000 nid=0x700 in Object.wait() [0x000000002554f000]

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

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

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

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

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

                      - locked <0x00000000d0e534d8> (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)

                   

                  "Raptor Metrics Engine Thread" #39 daemon prio=5 os_prio=0 tid=0x0000000022f34800 nid=0x166c waiting on condition [0x000000002532f000]

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

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

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

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

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

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

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

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

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

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

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

                   

                  "Scheduler" #38 daemon prio=5 os_prio=0 tid=0x0000000022f35000 nid=0xe80 in Object.wait() [0x000000002544f000]

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

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

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

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

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

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

                   

                  "Log Poller" #37 prio=1 os_prio=-2 tid=0x0000000022f37800 nid=0x1e08 waiting on condition [0x0000000024a2f000]

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

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

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

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

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

                      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:333)

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

                   

                  "TimedCache-Timer" #29 daemon prio=5 os_prio=0 tid=0x0000000016748800 nid=0x1614 in Object.wait() [0x000000001f0af000]

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

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

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

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

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

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

                   

                  "Framework Event Dispatcher" #25 daemon prio=5 os_prio=0 tid=0x0000000016748000 nid=0x148c in Object.wait() [0x000000001eb9f000]

                     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.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)

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

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

                   

                  "Inactive RequestProcessor thread [Was:Folder recognizer/org.openide.loaders.FolderList$ListTask]" #24 daemon prio=5 os_prio=0 tid=0x0000000016747000 nid=0x1718 in Object.wait() [0x000000001e89f000]

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

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

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

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

                   

                  "State Data Manager" #23 daemon prio=5 os_prio=0 tid=0x000000001675c800 nid=0x750 waiting on condition [0x000000001e79f000]

                     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" #22 prio=5 os_prio=0 tid=0x000000001d5b2800 nid=0x1af4 in Object.wait() [0x000000001e69f000]

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

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

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

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

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

                   

                  "Active Reference Queue Daemon" #18 daemon prio=1 os_prio=-2 tid=0x0000000016672000 nid=0xda0 in Object.wait() [0x0000000017def000]

                     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.java:57)

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

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

                   

                  "TimerQueue" #16 daemon prio=5 os_prio=0 tid=0x00000000163e5000 nid=0x132c waiting on condition [0x00000000179ef000]

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

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

                      - parking to wait for  <0x00000000ce94b190> (a java.util.concurrent.locks.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:171)

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

                   

                  "AWT-EventQueue-0" #15 prio=6 os_prio=0 tid=0x00000000163fd800 nid=0x1204 waiting on condition [0x000000001704f000]

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

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

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

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

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

                      at java.awt.EventQueue.getNextEvent(EventQueue.java:554)

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

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

                      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)

                   

                  "AWT-Windows" #13 daemon prio=6 os_prio=0 tid=0x00000000163fc800 nid=0x280 runnable [0x0000000016f4f000]

                     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)

                   

                  "AWT-Shutdown" #12 prio=5 os_prio=0 tid=0x00000000163f9800 nid=0x1cf0 in Object.wait() [0x0000000016d4f000]

                     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 <0x00000000ce95c5e8> (a java.lang.Object)

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

                   

                  "Java2D Disposer" #11 daemon prio=10 os_prio=2 tid=0x00000000163f9000 nid=0x1458 in Object.wait() [0x0000000016c4f000]

                     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 <0x00000000ce4f6e50> (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)

                   

                  "Service Thread" #9 daemon prio=9 os_prio=0 tid=0x0000000015c9d000 nid=0x290 runnable [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "C1 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x000000001440f000 nid=0x9e4 waiting on condition [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x0000000014409000 nid=0x14bc waiting on condition [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x0000000014406000 nid=0x13ec waiting on condition [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x0000000014404000 nid=0x14b4 waiting on condition [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x0000000014403000 nid=0x1548 runnable [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x00000000143ca000 nid=0x15b4 in Object.wait() [0x000000001576f000]

                     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 <0x00000000ce1829b8> (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)

                   

                  "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000002556800 nid=0x1bb4 in Object.wait() [0x000000001566f000]

                     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$ReferenceHandler.run(Reference.java:157)

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

                   

                  "main" #1 prio=5 os_prio=0 tid=0x0000000002464800 nid=0x11ec waiting on condition [0x0000000000000000]

                     java.lang.Thread.State: RUNNABLE

                   

                  "VM Thread" os_prio=2 tid=0x00000000143c8800 nid=0xd20 runnable

                   

                  "GC task thread#0 (ParallelGC)" os_prio=0 tid=0x000000000247a000 nid=0x7e0 runnable

                   

                  "GC task thread#1 (ParallelGC)" os_prio=0 tid=0x000000000247b800 nid=0xd44 runnable

                   

                  "GC task thread#2 (ParallelGC)" os_prio=0 tid=0x000000000247d800 nid=0xff4 runnable

                   

                  "GC task thread#3 (ParallelGC)" os_prio=0 tid=0x000000000247f000 nid=0x1920 runnable

                   

                  "VM Periodic Task Thread" os_prio=2 tid=0x0000000015ca3800 nid=0x16c8 waiting on condition

                   

                  JNI global references: 2539

                  • 6. Re: Oracle SQL Developer issue
                    Gary Graham-Oracle

                    OK, thanks, that's much better.

                     

                    In this latest full thread dump, we can see the thread "AliveLockThread.euro@db" in a BLOCKED state, waiting on "pool-2-thread-1", the long running query, which is in a RUNNABLE state, continuing to fetch rows from the DB.  The query has the DB connection locked and AliveLockThread is trying to access the same connection.

                     

                    In any case, it is unexpected that the UI won't let you do anything else. Perhaps this has something to do with whether you use a JDBC thin or thick (OCI) connection, are connecting to an older version of Oracle DB, or something like that.  In the past (say, 2 or more years ago), when this subject came up the focus was on JDBC driver bugs, use of OCI, whether DB connections are shared or dedicated, and whether -Doracle.net.disableOob=true would help.

                     

                    If you have time to read it, here is good sample of such discussions, along with the related links within it... How to cancel long query?

                    • 7. Re: Oracle SQL Developer issue
                      Gary Graham-Oracle

                      After a bit more investigation, I believe the following advice will help you avoid situations where a query appears to have been cancelled but...

                      1. It remains running on the DB.

                      2. Subsequent attempts to use or disconnect that connection get blocked.

                      3. Some other action (like trying to close SQL Developer) causes the UI to hang completely.

                      Your first choice should be to install an Oracle client (either full or instant) and configure SQL Developer in Tools > Preferences > Database > Advanced to use the OCI/Thick JDBC driver.

                       

                      If you don't want to install an Oracle client and prefer using the default Thin JDBC driver, then adding this to your install's sqldeveloper.conf file should help:

                      AddVMOption -Doracle.net.disableOob=true

                      The full thread dump you provide just reflects the fact that the query did not actually get cancelled, the connection is locked, and any other attempt to use it will get blocked. Anyway, as long as the UI does not hang, even if a query does not get cancelled at the DB level you should still be able to do things like...

                      1. Open an unshared connection (Ctrl+Shift+N) from the busy worksheet of that connection.

                      2. Create another connection name with the same details as the locked connection and use it instead.

                      3. Open Tools > Monitor Sessions for a user with sufficient authority and kill the hanging session using the context menu's Kill item.

                      Hope this helps.

                      • 8. Re: Oracle SQL Developer issue
                        Konstantinos Tsividis

                        Thanks a lot.

                        • The first choice using oracle client (i use an instant client that i had downloaded) works fine.
                        • The second adding "AddVMOption -Doracle.net.disableOob=true" to the "sqldeveloper.conf" file didn't work for me.