SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql developer slow when working on big packages.

BgilisDec 18 2017 — edited Dec 19 2017

Hello,

this thread is related to this one.

I'm currently using Sql developer 17.3.1.279 and I'm still facing this problem with packages over 3K lines.

While copy/pasting or compiling a package, the Interface may be stuck for 2-10 minutes... The only solution is to restart Sql developer. The problem occurs after 5 to 10 changes to the package.

Here is the java Stack as asked in the previous post.

Thanks

UsersCache.fillIn() time = 3 ret==null?: false

2017-12-18 13:45:45

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

"QuickDiffMargin" #1194 prio=5 os_prio=0 tid=0x000000001e7e4800 nid=0x4778 waiting on condition [0x000000001ef2e000]

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

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

- parking to wait for <0x00000000dfaefc20> (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.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:467)

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

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

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

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

"Inactive RequestProcessor thread [Was:oracle.ideimpl.markers.MasterMarkerStore/null]" #1193 daemon prio=1 os_prio=-2 tid=0x000000001e7e3000 nid=0xef4 in Object.wait() [0x000000001d49f000]

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

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

"TimedSoftReference" #1192 daemon prio=1 os_prio=-2 tid=0x000000001e7e1000 nid=0x17c4 runnable [0x000000001c99f000]

java.lang.Thread.State: RUNNABLE

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

at org.openide.util.Task.notifyRunning(Task.java:215)

- locked <0x00000000e8ed2268> (a org.openide.util.RequestProcessor$Task)

at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1442)

at org.netbeans.modules.openide.util.GlobalLookup.execute(GlobalLookup.java:68)

at org.openide.util.lookup.Lookups.executeWith(Lookups.java:303)

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

"Inactive RequestProcessor thread [Was:MarkableText/org.openide.util.RequestProcessor$ScheduledRPFutureTask]" #1188 daemon prio=1 os_prio=-2 tid=0x000000001e7de800 nid=0x44c8 in Object.wait() [0x00000000197ce000]

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

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

"Background Parser#9" #956 prio=6 os_prio=0 tid=0x000000001e7e2800 nid=0x4264 waiting on condition [0x00000000205fe000]

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

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

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

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

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

"Background Parser#6" #848 prio=6 os_prio=0 tid=0x000000001e56d000 nid=0x4780 runnable [0x000000001d09e000]

java.lang.Thread.State: RUNNABLE

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

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

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

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

"Background Parser#3" #583 prio=6 os_prio=0 tid=0x000000001e3ba800 nid=0x1d40 waiting on condition [0x000000001ca9f000]

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

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

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

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

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

"Image Animator 0" #575 daemon prio=3 os_prio=-1 tid=0x000000001e3b7800 nid=0x4514 runnable [0x0000000019aae000]

java.lang.Thread.State: RUNNABLE

at sun.awt.image.ImageRepresentation.setPixels(ImageRepresentation.java:516)

- locked <0x00000000e49f45b8> (a sun.awt.image.ImageRepresentation)

at sun.awt.image.ImageDecoder.setPixels(ImageDecoder.java:126)

at sun.awt.image.GifImageDecoder.sendPixels(GifImageDecoder.java:447)

at sun.awt.image.GifImageDecoder.parseImage(Native Method)

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

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)

"Background Parser#1" #556 prio=6 os_prio=0 tid=0x000000001e3b9800 nid=0x4594 runnable [0x000000001bb6f000]

java.lang.Thread.State: RUNNABLE

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

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

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

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

"Swing-Shell" #414 daemon prio=5 os_prio=0 tid=0x0000000024590800 nid=0x2614 waiting on condition [0x000000001cf9e000]

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

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

- parking to wait for <0x00000000e27ad058> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

at sun.awt.shell.Win32ShellFolderManager2$ComInvoker$3.run(Win32ShellFolderManager2.java:547)

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

"SwingWorker-pool-5-thread-10" #245 daemon prio=5 os_prio=0 tid=0x0000000024591000 nid=0x3100 waiting on condition [0x000000001c89f000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-9" #219 daemon prio=5 os_prio=0 tid=0x000000001e577000 nid=0x1e84 waiting on condition [0x000000001c79e000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-8" #211 daemon prio=5 os_prio=0 tid=0x000000001e56e800 nid=0x3d00 runnable [0x000000001be6e000]

java.lang.Thread.State: RUNNABLE

at oracle.dbtools.parser.Earley.complete(Earley.java:524)

at oracle.dbtools.parser.plsql.SqlEarley.parse(SqlEarley.java:886)

at oracle.dbtools.parser.plsql.LazyNode.expand(LazyNode.java:233)

- locked <0x00000000e5f87ca8> (a oracle.dbtools.parser.plsql.LazyNode)

at oracle.dbtools.parser.plsql.LazyNode.expand(LazyNode.java:206)

at oracle.dbtools.parser.plsql.IdentifiersDb.collectIdentifiers(IdentifiersDb.java:205)

at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.getIdentifierDefinition(IdentifierDefinitionLookup.java:787)

at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.parseIdentifierAtOffset(IdentifierDefinitionLookup.java:432)

at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.finishIdSelection(IdentifierDefinitionLookup.java:847)

at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.getIdentifierAtOffset(IdentifierDefinitionLookup.java:829)

at oracle.ide.ceditor.AbstractBrowseClickPlugin.getRegionFor(AbstractBrowseClickPlugin.java:150)

at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.access$500(IdentifierDefinitionLookup.java:68)

at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup$1.doInBackground(IdentifierDefinitionLookup.java:950)

at javax.swing.SwingWorker$1.call(SwingWorker.java:295)

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

at javax.swing.SwingWorker.run(SwingWorker.java:334)

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

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

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

"SwingWorker-pool-5-thread-7" #210 daemon prio=5 os_prio=0 tid=0x000000001e571800 nid=0x441c waiting on condition [0x00000000199ae000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-6" #174 daemon prio=5 os_prio=0 tid=0x0000000024592800 nid=0x274 waiting on condition [0x000000001c59e000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-5" #156 daemon prio=5 os_prio=0 tid=0x0000000024592000 nid=0x43c8 waiting on condition [0x000000001bc6f000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-4" #148 daemon prio=5 os_prio=0 tid=0x0000000024586800 nid=0x462c waiting on condition [0x000000001b5df000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-3" #129 daemon prio=5 os_prio=0 tid=0x000000002458f000 nid=0x10e4 waiting on condition [0x000000001bd6f000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-2" #111 daemon prio=5 os_prio=0 tid=0x000000002458f800 nid=0x3f10 waiting on condition [0x000000001ba6e000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"SwingWorker-pool-5-thread-1" #104 daemon prio=5 os_prio=0 tid=0x0000000024589800 nid=0x436c waiting on condition [0x000000001b06f000]

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

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

- parking to wait for <0x00000000dfae1e88> (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 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)

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

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

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

"TextBufferScavenger" #99 prio=5 os_prio=0 tid=0x0000000024587800 nid=0x4468 in Object.wait() [0x000000001a96f000]

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 <0x00000000dfd909d0> (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" #71 daemon prio=4 os_prio=-1 tid=0x0000000024589000 nid=0x1440 in Object.wait() [0x000000001ab6f000]

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

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

"Timer-3" #70 daemon prio=5 os_prio=0 tid=0x000000002458c000 nid=0x44f0 in Object.wait() [0x000000001aa6e000]

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 <0x00000000df5212e0> (a java.util.TaskQueue)

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

"pool-4-thread-1" #68 prio=5 os_prio=0 tid=0x0000000024588000 nid=0x3fac runnable [0x000000001a66e000]

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

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

- parking to wait for <0x00000000df679460> (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:1074)

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

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

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

"IconOverlayTracker Timer: null-jdbcNodeInfoType" #57 prio=5 os_prio=0 tid=0x0000000018445800 nid=0x387c in Object.wait() [0x000000001a00f000]

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 <0x00000000de1dba18> (a java.util.TaskQueue)

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

"status-0" #55 prio=2 os_prio=-2 tid=0x000000001e576000 nid=0x1630 waiting on condition [0x00000000192ce000]

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

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

- parking to wait for <0x00000000dd46b910> (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:1074)

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

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

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

"WaitCursor-Timer" #49 prio=6 os_prio=0 tid=0x000000001e577800 nid=0x3bb0 in Object.wait() [0x00000000190cf000]

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 <0x00000000dd3e0670> (a java.util.TaskQueue)

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

"WeakDataReference polling" #48 prio=1 os_prio=-2 tid=0x000000001e578800 nid=0x33f8 in Object.wait() [0x0000000018fcf000]

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 <0x00000000dd5c8160> (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:748)

"InterruptTimer" #47 daemon prio=5 os_prio=0 tid=0x000000001e575800 nid=0x22e4 in Object.wait() [0x0000000028d1f000]

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 <0x00000000d5c786e8> (a java.util.TaskQueue)

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

"RaptorTaskThread02" #46 prio=5 os_prio=0 tid=0x000000001e573000 nid=0x2528 waiting on condition [0x000000002988e000]

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

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

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

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

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

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

at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

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

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

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

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

"Thread-10" #41 daemon prio=5 os_prio=0 tid=0x000000001e56e000 nid=0x473c in Object.wait() [0x000000002845e000]

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.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1482)

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

"ChangeSetService" #37 daemon prio=1 os_prio=-2 tid=0x000000001e570000 nid=0xc3c in Object.wait() [0x0000000027a5f000]

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

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

- waiting on <0x00000000d53664a8> (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 <0x00000000d53664a8> (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:748)

"Raptor Metrics Engine Thread" #36 daemon prio=5 os_prio=0 tid=0x000000001e56b000 nid=0x840 waiting on condition [0x000000002715f000]

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

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

- parking to wait for <0x00000000cf8a34e0> (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:1074)

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

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

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

"Scheduler" #35 daemon prio=5 os_prio=0 tid=0x000000001e56c800 nid=0x3c6c in Object.wait() [0x00000000250df000]

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 <0x00000000cf8c0728> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)

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

"Log Poller" #34 prio=1 os_prio=-2 tid=0x000000001e56b800 nid=0x42f4 waiting on condition [0x00000000239cf000]

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

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

- parking to wait for <0x00000000cf8c0f10> (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:748)

"TimedCache-Timer" #30 daemon prio=5 os_prio=0 tid=0x0000000018447000 nid=0x4504 in Object.wait() [0x0000000021bcf000]

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 <0x00000000cf34a448> (a java.util.TaskQueue)

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

"Framework Event Dispatcher" #26 daemon prio=6 os_prio=0 tid=0x0000000018444000 nid=0x1c54 in Object.wait() [0x00000000208ff000]

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 <0x00000000ce8ad198> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

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

"State Data Manager" #24 daemon prio=5 os_prio=0 tid=0x0000000018444800 nid=0x1668 waiting on condition [0x00000000204ff000]

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

"Framework Active Thread" #23 prio=5 os_prio=0 tid=0x0000000018443000 nid=0x42e8 in Object.wait() [0x00000000203ff000]

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

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

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

"Active Reference Queue Daemon" #19 daemon prio=1 os_prio=-2 tid=0x0000000018255000 nid=0x2728 in Object.wait() [0x000000001a56f000]

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

at org.openide.util.lookup.implspi.ActiveQueue$Impl.removeSuper(ActiveQueue.java:93)

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

"TimerQueue" #17 daemon prio=5 os_prio=0 tid=0x000000001802a800 nid=0x1b04 runnable [0x000000001a16e000]

java.lang.Thread.State: RUNNABLE

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

- parking to wait for <0x00000000ce7ad160> (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:174)

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

"AWT-EventQueue-0" #16 prio=6 os_prio=0 tid=0x0000000017f66800 nid=0xa1c runnable [0x0000000018ebc000]

java.lang.Thread.State: RUNNABLE

at sun.font.T2KFontScaler.getGlyphImageNative(Native Method)

at sun.font.T2KFontScaler.getGlyphImage(T2KFontScaler.java:117)

- locked <0x00000000d554f9c8> (a sun.font.T2KFontScaler)

at sun.font.FileFont.getGlyphImage(FileFont.java:208)

at sun.font.FileFontStrike.getGlyphImagePtr(FileFontStrike.java:392)

at sun.font.FileFontStrike.getGlyphAdvance(FileFontStrike.java:691)

at sun.font.FileFontStrike.getGlyphAdvance(FileFontStrike.java:602)

at sun.font.CompositeStrike.getGlyphAdvance(CompositeStrike.java:147)

at sun.font.CompositeStrike.getCodePointAdvance(CompositeStrike.java:158)

at sun.font.FontDesignMetrics.handleCharWidth(FontDesignMetrics.java:416)

at sun.font.FontDesignMetrics.getLatinCharWidth(FontDesignMetrics.java:425)

at sun.font.FontDesignMetrics.stringWidth(FontDesignMetrics.java:476)

at sun.swing.SwingUtilities2.stringWidth(SwingUtilities2.java:403)

at sun.swing.SwingUtilities2.drawStringUnderlineCharAt(SwingUtilities2.java:631)

at javax.swing.plaf.basic.BasicMenuItemUI.paintText(BasicMenuItemUI.java:699)

at javax.swing.plaf.basic.BasicMenuItemUI.paintText(BasicMenuItemUI.java:603)

at javax.swing.plaf.basic.BasicMenuItemUI.paintMenuItem(BasicMenuItemUI.java:504)

at com.jgoodies.looks.common.ExtBasicMenuUI.paintMenuItem(ExtBasicMenuUI.java:140)

at com.jgoodies.looks.plastic.PlasticMenuUI.paintMenuItem(PlasticMenuUI.java:103)

at oracle.javatools.ui.plaf.theme.ThemedMenuUI.paintMenuItem(ThemedMenuUI.java:95)

at javax.swing.plaf.basic.BasicMenuItemUI.paint(BasicMenuItemUI.java:475)

at javax.swing.plaf.basic.BasicMenuItemUI.update(BasicMenuItemUI.java:471)

at javax.swing.JComponent.paintComponent(JComponent.java:780)

at javax.swing.JComponent.paint(JComponent.java:1056)

at javax.swing.JComponent.paintChildren(JComponent.java:889)

- locked <0x00000000ce002458> (a java.awt.Component$AWTTreeLock)

at javax.swing.JComponent.paint(JComponent.java:1065)

at javax.swing.JComponent.paintChildren(JComponent.java:889)

- locked <0x00000000ce002458> (a java.awt.Component$AWTTreeLock)

at javax.swing.JComponent.paint(JComponent.java:1065)

at javax.swing.JLayeredPane.paint(JLayeredPane.java:586)

at javax.swing.JComponent.paintChildren(JComponent.java:889)

- locked <0x00000000ce002458> (a java.awt.Component$AWTTreeLock)

at javax.swing.JComponent.paint(JComponent.java:1065)

at javax.swing.JComponent.paintToOffscreen(JComponent.java:5210)

at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1579)

at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1502)

at javax.swing.RepaintManager.paint(RepaintManager.java:1272)

at javax.swing.JComponent._paintImmediately(JComponent.java:5158)

at javax.swing.JComponent.paintImmediately(JComponent.java:4969)

at javax.swing.JComponent.paintImmediately(JComponent.java:4950)

at javax.swing.JLayer.paintImmediately(JLayer.java:415)

at javax.swing.plaf.LayerUI.paintImmediately(LayerUI.java:717)

at javax.swing.JLayer.paintImmediately(JLayer.java:410)

at javax.swing.JComponent.paintImmediately(JComponent.java:4950)

at javax.swing.RepaintManager$4.run(RepaintManager.java:831)

at javax.swing.RepaintManager$4.run(RepaintManager.java:814)

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

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:814)

at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:789)

at javax.swing.RepaintManager.prePaintDirtyRegions(RepaintManager.java:738)

at javax.swing.RepaintManager.access$1200(RepaintManager.java:64)

at javax.swing.RepaintManager$ProcessingRunnable.run(RepaintManager.java:1732)

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

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

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

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

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

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

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

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

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

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" #14 daemon prio=6 os_prio=0 tid=0x0000000017f65000 nid=0x3804 runnable [0x0000000018dbf000]

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

"AWT-Shutdown" #13 prio=5 os_prio=0 tid=0x0000000017f55800 nid=0x478c in Object.wait() [0x0000000018cbf000]

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

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

"Java2D Disposer" #12 daemon prio=10 os_prio=2 tid=0x0000000017f55000 nid=0x1b4c in Object.wait() [0x0000000018bbf000]

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 <0x00000000ce641f40> (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:748)

"Service Thread" #10 daemon prio=9 os_prio=0 tid=0x0000000016e20000 nid=0x13e4 runnable [0x0000000000000000]

java.lang.Thread.State: RUNNABLE

"C1 CompilerThread3" #9 daemon prio=9 os_prio=2 tid=0x0000000014e9e000 nid=0x3ec8 waiting on condition [0x0000000000000000]

java.lang.Thread.State: RUNNABLE

"C2 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x0000000014e9b000 nid=0x1328 waiting on condition [0x0000000000000000]

java.lang.Thread.State: RUNNABLE

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

java.lang.Thread.State: RUNNABLE

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

java.lang.Thread.State: RUNNABLE

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

java.lang.Thread.State: RUNNABLE

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

java.lang.Thread.State: RUNNABLE

"Finalizer" #3 daemon prio=8 os_prio=1 tid=0x0000000016da0800 nid=0x3fdc in Object.wait() [0x000000001727f000]

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 <0x00000000ce498280> (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=0x0000000002b7b000 nid=0x461c in Object.wait() [0x0000000016d7e000]

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

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

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

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

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

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

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

java.lang.Thread.State: RUNNABLE

"VM Thread" os_prio=2 tid=0x0000000014e87000 nid=0x43dc runnable

"GC task thread#0 (ParallelGC)" os_prio=0 tid=0x0000000002a9a800 nid=0x425c runnable

"GC task thread#1 (ParallelGC)" os_prio=0 tid=0x0000000002a9c000 nid=0x409c runnable

"GC task thread#2 (ParallelGC)" os_prio=0 tid=0x0000000002a9e000 nid=0x1774 runnable

"GC task thread#3 (ParallelGC)" os_prio=0 tid=0x0000000002aa0000 nid=0x43a8 runnable

"GC task thread#4 (ParallelGC)" os_prio=0 tid=0x0000000002aa2000 nid=0x4050 runnable

"GC task thread#5 (ParallelGC)" os_prio=0 tid=0x0000000002aa3000 nid=0x2488 runnable

"GC task thread#6 (ParallelGC)" os_prio=0 tid=0x0000000002aa6800 nid=0x3e9c runnable

"GC task thread#7 (ParallelGC)" os_prio=0 tid=0x0000000002aa7800 nid=0x3cb0 runnable

"VM Periodic Task Thread" os_prio=2 tid=0x0000000016e1a800 nid=0x28f8 waiting on condition

JNI global references: 3903

Heap

PSYoungGen total 179712K, used 89088K [0x00000000ef580000, 0x00000000ffe00000, 0x0000000100000000)

eden space 89088K, 100% used [0x00000000ef580000,0x00000000f4c80000,0x00000000f4c80000)

from space 90624K, 0% used [0x00000000fa500000,0x00000000fa500000,0x00000000ffd80000)

to space 90624K, 0% used [0x00000000f4c80000,0x00000000f4c80000,0x00000000fa500000)

ParOldGen total 546304K, used 546279K [0x00000000ce000000, 0x00000000ef580000, 0x00000000ef580000)

object space 546304K, 99% used [0x00000000ce000000,0x00000000ef579fc0,0x00000000ef580000)

Metaspace used 130383K, capacity 138854K, committed 139288K, reserved 1169408K

class space used 17601K, capacity 20196K, committed 20272K, reserved 1048576K

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2018

Added on Dec 18 2017

#sql-developer

9 comments

743 views