Skip to Main Content

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 freezing, I have the logging info

chuckersApr 17 2015 — edited Apr 17 2015

My colleague has been using SQL Developer off and on for over a year, and is the only person experiencing intermittent freezing in the tool. Once the freeze initiates, he's hosed We found Jeff's website (http://www.thatjeffsmith.com/archive/2012/06/how-to-collect-debug-info-for-oracle-sql-developer/) indicating how to collect debug information.

We're all working from the same Citrix environment, so it's really strange. We've tried removing the \SQLDeveloper folder where all of his profile information is stored, but it's without remedy. Here's our specific environmental description, plus the contents of the logfile.

Thank you any help you can provide.

--=Chuck

SQL Developer version 4.0.3.16

JDK version 1.7

Windows 2008R2 (Citrix server environment)

Oracle version 11.2.0.3

        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followScan(Earley.java:891)
        at oracle.dbtools.parser.Earley.tree(Earley.java:855)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followScan(Earley.java:891)
        at oracle.dbtools.parser.Earley.tree(Earley.java:855)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followScan(Earley.java:891)
        at oracle.dbtools.parser.Earley.tree(Earley.java:855)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:947)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:945)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:947)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:947)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followScan(Earley.java:891)
        at oracle.dbtools.parser.Earley.tree(Earley.java:855)
        at oracle.dbtools.parser.Earley.followScan(Earley.java:891)
        at oracle.dbtools.parser.Earley.tree(Earley.java:855)
        at oracle.dbtools.parser.Earley.followScan(Earley.java:891)
        at oracle.dbtools.parser.Earley.tree(Earley.java:855)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:947)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.followComplete(Earley.java:950)
        at oracle.dbtools.parser.Earley.tree(Earley.java:857)
        at oracle.dbtools.parser.Earley.treeForACell(Earley.java:832)
        at oracle.dbtools.parser.Parser.forest(Parser.java:84)
        at oracle.dbtools.parser.plsql.LazyNode.expand(LazyNode.java:225)
        at oracle.dbtools.parser.plsql.IdentifiersDb.collectIdentifiers(IdentifiersDb.java:204)
        at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.getIdentifierDefinition(IdentifierDefinitionLookup.java:743)
        at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.parseIdentifierAtOffset(IdentifierDefinitionLookup.java:409)
        at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.finishIdSelection(IdentifierDefinitionLookup.java:803)
        at oracle.dbtools.parser.plsql.IdentifierDefinitionLookup.getIdentifierAtOffset(IdentifierDefinitionLookup.java:785)
        at oracle.ide.ceditor.AbstractBrowseClickPlugin.getRegionFor(AbstractBrowseClickPlugin.java:150)
        at oracle.javatools.editor.plugins.AbstractClickPlugin.updateHighlight(AbstractClickPlugin.java:442)
        at oracle.javatools.editor.plugins.AbstractClickPlugin.actionPerformed(AbstractClickPlugin.java:240)
        at javax.swing.Timer.fireActionPerformed(Timer.java:312)
        at javax.swing.Timer$DoPostEvent.run(Timer.java:244)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
        at java.awt.EventQueue.access$200(EventQueue.java:103)
        at java.awt.EventQueue$3.run(EventQueue.java:694)
        at java.awt.EventQueue$3.run(EventQueue.java:692)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
        at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
        at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

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

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

"AWT-Windows" daemon prio=6 tid=0x000000000c9af000 nid=0x3c5c runnable [0x000000000f4ff000]
   java.lang.Thread.State: RUNNABLE
        at sun.awt.windows.WToolkit.eventLoop(Native Method)
        at sun.awt.windows.WToolkit.run(WToolkit.java:307)
        at java.lang.Thread.run(Thread.java:745)

"AWT-Shutdown" prio=6 tid=0x000000000c9ac000 nid=0x3818 in Object.wait() [0x000000000f3ff000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x00000000cead9a28> (a java.lang.Object)
        at java.lang.Object.wait(Object.java:503)
        at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:296)
        - locked <0x00000000cead9a28> (a java.lang.Object)
        at java.lang.Thread.run(Thread.java:745)

"Java2D Disposer" daemon prio=10 tid=0x000000000c9ab000 nid=0x3df0 in Object.wait() [0x000000000f2ff000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x00000000cea145b0> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
        - locked <0x00000000cea145b0> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
        at sun.java2d.Disposer.run(Disposer.java:145)
        at java.lang.Thread.run(Thread.java:745)

"Service Thread" daemon prio=6 tid=0x000000000c840000 nid=0x2460 runnable [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"C2 CompilerThread1" daemon prio=10 tid=0x000000000c837000 nid=0x2e58 waiting on
condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"C2 CompilerThread0" daemon prio=10 tid=0x000000000c81e800 nid=0x3474 waiting on
condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"Attach Listener" daemon prio=10 tid=0x000000000c818800 nid=0x3ff8 runnable [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"Signal Dispatcher" daemon prio=10 tid=0x000000000c818000 nid=0x3c30 waiting on
condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"Finalizer" daemon prio=8 tid=0x000000000a5aa800 nid=0x37e4 in Object.wait() [0x000000000eb3f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x00000000ce9edcb8> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
        - locked <0x00000000ce9edcb8> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
        at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)

"Reference Handler" daemon prio=10 tid=0x000000000a5a2800 nid=0x1570 in Object.wait() [0x000000000ea3f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x00000000ce8f4cd8> (a java.lang.ref.Reference$Lock)
        at java.lang.Object.wait(Object.java:503)
        at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133)
        - locked <0x00000000ce8f4cd8> (a java.lang.ref.Reference$Lock)

"main" prio=6 tid=0x0000000003535800 nid=0x2be8 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"VM Thread" prio=10 tid=0x000000000c7c7000 nid=0x3ce4 runnable

"GC task thread#0 (ParallelGC)" prio=6 tid=0x000000000354c000 nid=0x25c4 runnable

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

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

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

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

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

"GC task thread#6 (ParallelGC)" prio=6 tid=0x0000000003556800 nid=0x360c runnable

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

"GC task thread#8 (ParallelGC)" prio=6 tid=0x000000000355e000 nid=0x31a8 runnable

"GC task thread#9 (ParallelGC)" prio=6 tid=0x0000000003561000 nid=0x299c runnable

"GC task thread#10 (ParallelGC)" prio=6 tid=0x0000000003563800 nid=0x3790 runnable

"GC task thread#11 (ParallelGC)" prio=6 tid=0x0000000003564800 nid=0x38c4 runnable

"GC task thread#12 (ParallelGC)" prio=6 tid=0x0000000003565000 nid=0x2860 runnable

"GC task thread#13 (ParallelGC)" prio=6 tid=0x0000000003566000 nid=0x39dc runnable

"GC task thread#14 (ParallelGC)" prio=6 tid=0x0000000003569000 nid=0x32d0 runnable

"GC task thread#15 (ParallelGC)" prio=6 tid=0x0000000003569800 nid=0x16f0 runnable

"GC task thread#16 (ParallelGC)" prio=6 tid=0x000000000356e800 nid=0x3a70 runnable

"GC task thread#17 (ParallelGC)" prio=6 tid=0x0000000003573000 nid=0x3dbc runnable

"VM Periodic Task Thread" prio=10 tid=0x000000000c849000 nid=0x3c60 waiting on condition

JNI global references: 2667

Heap
PSYoungGen      total 256000K, used 243298K [0x00000000ef500000, 0x0000000100000000, 0x0000000100000000)
  eden space 238592K, 94% used [0x00000000ef500000,0x00000000fd19a208,0x00000000fde00000)
  from space 17408K, 99% used [0x00000000fde00000,0x00000000feefe8a0,0x00000000fef00000)
  to   space 17408K, 0% used [0x00000000fef00000,0x00000000fef00000,0x0000000100000000)
ParOldGen       total 155136K, used 130822K [0x00000000ce000000, 0x00000000d7780000, 0x00000000ef500000)
  object space 155136K, 84% used [0x00000000ce000000,0x00000000d5fc1a20,0x00000000d7780000)
PSPermGen       total 149504K, used 93999K [0x00000000be000000, 0x00000000c7200000, 0x00000000ce000000)
  object space 149504K, 62% used [0x00000000be000000,0x00000000c3bcbd08,0x00000000c7200000)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2015
Added on Apr 17 2015
1 comment
889 views