4 Replies Latest reply on Sep 16, 2014 4:54 PM by Gary Graham-Oracle

    SQL Dev 4.0.2.15 freezing

    user13705395

      Hi, I'm having issues with SQL Dev 4.0.2.15 freezing up when I try to open a table from the schema browser.  I'll use the schema browser to find my table but when I click on it, the new tab opens but gets stuck with the message "Waiting for editor to initialize".

       

      I tried updating the Xms value from 128m to 256m in product.conf per Re: SQL Developer Unresponsive.  I've also turned off auto-updating and the load time was relatively low.

       

      Dump is below.

       

      Thanks for the help!

       

      Microsoft Windows [Version 6.1.7601]

      Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

       

       

      C:\Users\gmccullough>cd "c:\Program Files"

       

       

      c:\Program Files>cd "SQL Developer"

       

       

      c:\Program Files\SQL Developer>cd sqldeveloper

       

       

      c:\Program Files\SQL Developer\sqldeveloper>cd bin

       

       

      c:\Program Files\SQL Developer\sqldeveloper\bin>sqldeveloper.exe

       

       

       

       

      LOAD TIME : 307UsersCache.fillIn() time = 15  ret==null?: false

      2014-09-15 10:42:39

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

       

       

      "RaptorTask: Displaying Results" prio=6 tid=0x000000000b5ef000 nid=0x1020 waitin

      g on condition [0x0000000011f1f000]

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

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

              - parking to wait for  <0x00000000d2293ac0> (a java.util.concurrent.Sync

      hronousQueue$TransferStack)

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

      )

              at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(Sync

      hronousQueue.java:460)

              at java.util.concurrent.SynchronousQueue$TransferStack.transfer(Synchron

      ousQueue.java:359)

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

       

       

              at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.ja

      va:1068)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

      java:1130)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

      .java:615)

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

       

       

      "Image Animator 0" daemon prio=4 tid=0x000000000b5e8000 nid=0x2380 waiting on co

      ndition [0x000000000e6af000]

         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.j

      ava:269)

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

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

       

       

      "Timer-4" prio=6 tid=0x000000000b220000 nid=0x1794 ^in Object.wait() C[0x0000000

      012c7f000]

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

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

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

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

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

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

       

       

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

       

       

      "Timer-3" c:\Program Files\SQL Developer\sqldeveloper\bin>prio=6 tid=0x000000000

      b21e800 nid=0x1974 in Object.wait() [0x000000001211f000]

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

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

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

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

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

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

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

       

       

      "Background Parser" prio=6 tid=0x000000000b21d800 nid=0x9a4 waiting on condition

      [0x0000000012b7f000]

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

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

              at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundPa

      rser.java:142)

              at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.j

      ava:115)

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

       

       

      "TextBufferScavenger" prio=6 tid=0x000000000b5e6800 nid=0xcd8 in Object.wait() [

      0x000000001201f000]

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

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

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

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

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

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

              at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBuffer

      Reference.java:145)

       

       

      "pool-3-thread-1" prio=6 tid=0x000000000b5e6000 nid=0x2310 waiting on condition

      [0x000000000abef000]

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

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

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

      s.AbstractQueuedSynchronizer$ConditionObject)

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

      )

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

      .awaitNanos(AbstractQueuedSynchronizer.java:2082)

              at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.tak

      e(ScheduledThreadPoolExecutor.java:1090)

              at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.tak

      e(ScheduledThreadPoolExecutor.java:807)

              at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.ja

      va:1068)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

      java:1130)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

      .java:615)

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

       

       

      "status-0" prio=2 tid=0x000000000b5ee800 nid=0x3d0 waiting on condition [0x00000

      0001297f000]

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

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

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

      s.AbstractQueuedSynchronizer$ConditionObject)

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

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

      .await(AbstractQueuedSynchronizer.java:2043)

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

              at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java

      :338)

              at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java

      :300)

              at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.ja

      va:1068)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

      java:1130)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

      .java:615)

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

       

       

      "Timer-2" prio=6 tid=0x000000000b5ed800 nid=0x1550 in Object.wait() [0x000000001

      287f000]

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

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

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

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

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

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

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

       

       

      "WeakDataReference polling" prio=2 tid=0x000000000b5ed000 nid=0x66c in Object.wa

      it() [0x000000001277f000]

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

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

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

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

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

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

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

      88)

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

       

       

      "WaitCursor-Timer" prio=6 tid=0x000000000b5ec000 nid=0x7ac in Object.wait() [0x0

      000000013e3f000]

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

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

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

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

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

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

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

       

       

      "IconOverlayTracker Timer: null-jdbcNodeInfoType" prio=6 tid=0x000000000b5ea800

      nid=0x23b0 in Object.wait() [0x000000001251f000]

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

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

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

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

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

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

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

       

       

      "pool-2-thread-1" prio=6 tid=0x000000000b5ea000 nid=0x22cc waiting on condition

      [0x000000001231f000]

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

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

              - parking to wait for  <0x00000000f7bb7128> (a java.util.concurrent.Futu

      reTask)

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

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

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

              at oracle.dbtools.raptor.oviewer.base.NavSelectionListener.raiseEditor(N

      avSelectionListener.java:699)

              at oracle.dbtools.raptor.oviewer.base.NavSelectionListener.open(NavSelec

      tionListener.java:523)

              at oracle.dbtools.raptor.oviewer.base.NavSelectionListener.access$1200(N

      avSelectionListener.java:83)

              at oracle.dbtools.raptor.oviewer.base.NavSelectionListener$3.doWork(NavS

      electionListener.java:336)

              at oracle.dbtools.raptor.oviewer.base.NavSelectionListener$3.doWork(NavS

      electionListener.java:288)

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

      193)

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

              at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTa

      sk.run(RaptorTaskManager.java:554)

              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47

      1)

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

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

      java:1145)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

      .java:615)

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

       

       

      "Scheduler" daemon prio=6 tid=0x000000000b5e9000 nid=0xcb8 in Object.wait() [0x0

      00000001221f000]

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

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

              - waiting on <0x00000000d2293880> (a oracle.dbtools.raptor.backgroundTas

      k.TaskLinkedList)

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

              at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(Task

      LinkedList.java:47)

              - locked <0x00000000d2293880> (a oracle.dbtools.raptor.backgroundTask.Ta

      skLinkedList)

              at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThrea

      d.run(RaptorTaskManager.java:479)

       

       

      "Thread-8" daemon prio=6 tid=0x000000000b5e5000 nid=0x232c in Object.wait() [0x0

      000000011e1f000]

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

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

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

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

              at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractP

      references.java:1476)

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

       

       

      "Log Poller" prio=2 tid=0x000000000b5e4800 nid=0x42c waiting on condition [0x000

      0000010d4f000]

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

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

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

      s.AbstractQueuedSynchronizer$ConditionObject)

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

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

      .await(AbstractQueuedSynchronizer.java:2043)

              at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.jav

      a:442)

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

      )

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

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

       

       

      "Inactive RequestProcessor thread [Was:NbStatusDisplayer/org.netbeans.core.NbSta

      tusDisplayer$MessageImpl]" daemon prio=2 tid=0x000000000b5e3800 nid=0x1a7c in Ob

      ject.wait() [0x0000000010c4f000]

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

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

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

              at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java

      :1989)

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

       

       

      "JarIndex Timer" daemon prio=6 tid=0x000000000b5e3000 nid=0x1088 in Object.wait(

      ) [0x0000000010b4f000]

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

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

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

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

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

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

       

       

      "Inactive RequestProcessor thread [Was:TimedSoftReference/org.openide.util.Timed

      SoftReference]" daemon prio=2 tid=0x000000000b5e0800 nid=0x5dc in Object.wait()

      [0x0000000010a4f000]

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

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

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

              at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java

      :1989)

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

       

       

      "TimedCache-Timer" daemon prio=6 tid=0x000000000b5e1800 nid=0x230c in Object.wai

      t() [0x000000000aaef000]

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

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

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

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

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

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

       

       

      "Framework Event Dispatcher" daemon prio=6 tid=0x000000000b5e0000 nid=0x1530 in

      Object.wait() [0x000000000a8ef000]

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

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

              - waiting on <0x00000000ce3be788> (a org.eclipse.osgi.framework.eventmgr

      .EventManager$EventThread)

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

              at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextE

      vent(EventManager.java:400)

              - locked <0x00000000ce3be788> (a org.eclipse.osgi.framework.eventmgr.Eve

      ntManager$EventThread)

              at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(Even

      tManager.java:336)

       

       

      "State Data Manager" daemon prio=6 tid=0x000000000b194000 nid=0xa88 waiting on c

      ondition [0x000000000a7ef000]

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

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

              at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.j

      ava:297)

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

       

       

      "Framework Active Thread" prio=6 tid=0x000000000b293800 nid=0x2208 in Object.wai

      t() [0x000000000a6ef000]

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

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

              - waiting on <0x00000000d0097598> (a org.eclipse.osgi.framework.internal

      .core.Framework)

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

      :1863)

              - locked <0x00000000d0097598> (a org.eclipse.osgi.framework.internal.cor

      e.Framework)

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

       

       

      "Inactive RequestProcessor thread [Was:Folder recognizer/org.openide.loaders.Fol

      derList$ListTask]" daemon prio=2 tid=0x000000000afb5000 nid=0x2078 in Object.wai

      t() [0x000000000e8af000]

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

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

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

              at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java

      :1989)

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

       

       

      "RequestProcessor queue manager" daemon prio=6 tid=0x000000000aef7000 nid=0x1950

      in Object.wait() [0x000000000e7af000]

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

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

              - waiting on <0x00000000ce3bebb8> (a java.lang.Class for org.openide.uti

      l.RequestProcessor$TickTac)

              at org.openide.util.RequestProcessor$TickTac.obtainFirst(RequestProcesso

      r.java:2267)

              - locked <0x00000000ce3bebb8> (a java.lang.Class for org.openide.util.Re

      questProcessor$TickTac)

              at org.openide.util.RequestProcessor$TickTac.run(RequestProcessor.java:2

      243)

       

       

      "Active Reference Queue Daemon" daemon prio=2 tid=0x000000000aee7000 nid=0x2034

      in Object.wait() [0x000000000b91f000]

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

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

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

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

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

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

      va:180)

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

       

       

      "TimerQueue" daemon prio=6 tid=0x0000000009ce6800 nid=0x23d0 waiting on conditio

      n [0x000000000b71f000]

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

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

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

      s.AbstractQueuedSynchronizer$ConditionObject)

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

      )

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

      .awaitNanos(AbstractQueuedSynchronizer.java:2082)

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

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

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

       

       

      "AWT-EventQueue-0" prio=6 tid=0x0000000009ab9800 nid=0x21b0 runnable [0x00000000

      0a41d000]

         java.lang.Thread.State: RUNNABLE

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

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

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

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

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

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

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

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

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

              at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSock

      etInputStreamWrapper.java:124)

              at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStr

      eamWrapper.java:80)

              at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)

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

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

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

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.

      java:204)

              at oracle.jdbc.driver.T4CCallableStatement.executeForDescribe(T4CCallabl

      eStatement.java:877)

              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme

      nt.java:1167)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme

      nt.java:1289)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep

      aredStatement.java:3584)

              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare

      dStatement.java:3628)

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

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(Oracle

      PreparedStatementWrapper.java:1493)

              at oracle.dbtools.db.DBUtil$2.call(DBUtil.java:365)

              at oracle.dbtools.db.DBUtil$2.call(DBUtil.java:353)

              at oracle.dbtools.db.DBUtil.lockForOperation(DBUtil.java:1701)

              at oracle.dbtools.db.DBUtil.executeOracleReturnOneCol(DBUtil.java:374)

              at oracle.dbtools.db.OracleUtil.executeReturnOneCol(OracleUtil.java:323)

       

       

              at oracle.dbtools.util.objectpriv.PrivCheck.canAlter(PrivCheck.java:38)

              at oracle.dbtools.util.objectpriv.PermissionRegistry.canAlter(Permission

      Registry.java:125)

              at oracle.dbtools.raptor.oviewer.xmleditor.XMLBasedEditor.checkCanEdit(X

      MLBasedEditor.java:344)

              at oracle.dbtools.raptor.oviewer.xmleditor.XMLBasedEditor.buildToolbar(X

      MLBasedEditor.java:439)

              at oracle.dbtools.raptor.oviewer.xmleditor.XMLBasedEditor.access$000(XML

      BasedEditor.java:69)

              at oracle.dbtools.raptor.oviewer.xmleditor.XMLBasedEditor$1.run(XMLBased

      Editor.java:429)

              at oracle.bali.ewt.util.PaintUtils.invokeAfterRepaint(PaintUtils.java:53

      )

              at oracle.javatools.util.SwingUtils.invokeAfterRepaint(SwingUtils.java:5

      63)

              at oracle.ide.editor.AsynchronousEditor$6.run(AsynchronousEditor.java:58

      1)

              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(ProtectionDo

      main.java:76)

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

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

      eueWrapper.java:169)

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

      ueWrapper.java:151)

              at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre

      ad.java:242)

              at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.

      java:161)

              at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre

      ad.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=0x0000000009ab4800 nid=0x2070 runnable [0x000000

      000a21f000]

         java.lang.Thread.State: RUNNABLE

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

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

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

       

       

      "AWT-Shutdown" prio=6 tid=0x0000000009ab0000 nid=0x11d0 in Object.wait() [0x0000

      00000a11f000]

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

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

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

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

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

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

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

       

       

      "Java2D Disposer" daemon prio=10 tid=0x0000000009aaf000 nid=0x2264 in Object.wai

      t() [0x000000000a01f000]

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

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

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

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

              - locked <0x00000000cea43ba8> (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=0x0000000008166000 nid=0x235c runnable [0x000

      0000000000000]

         java.lang.Thread.State: RUNNABLE

       

       

      "C2 CompilerThread1" daemon prio=10 tid=0x0000000008164800 nid=0x209c waiting on

      condition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

       

      "C2 CompilerThread0" daemon prio=10 tid=0x000000000815f000 nid=0x4b4 waiting on

      condition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

       

      "Attach Listener" daemon prio=10 tid=0x000000000815e000 nid=0x1f4c runnable [0x0

      000000000000000]

         java.lang.Thread.State: RUNNABLE

       

       

      "Signal Dispatcher" daemon prio=10 tid=0x0000000008157000 nid=0x2b0 waiting on c

      ondition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

       

      "Finalizer" daemon prio=8 tid=0x00000000080ff000 nid=0x197c in Object.wait() [0x

      000000000945f000]

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

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

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

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

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

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

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

       

       

      "Reference Handler" daemon prio=10 tid=0x00000000080f7000 nid=0xdb0 in Object.wa

      it() [0x000000000935f000]

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

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

              - waiting on <0x00000000ceef59b8> (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 <0x00000000ceef59b8> (a java.lang.ref.Reference$Lock)

       

       

      "main" prio=6 tid=0x000000000207b800 nid=0x23c8 waiting on condition [0x00000000

      00000000]

         java.lang.Thread.State: RUNNABLE

       

       

      "VM Thread" prio=10 tid=0x00000000080f1800 nid=0x22d8 runnable

       

       

      "GC task thread#0 (ParallelGC)" prio=6 tid=0x0000000002090000 nid=0x14b0 runnabl

      e

       

       

      "GC task thread#1 (ParallelGC)" prio=6 tid=0x0000000002092000 nid=0x2130 runnabl

      e

       

       

      "GC task thread#2 (ParallelGC)" prio=6 tid=0x0000000002093800 nid=0x15cc runnabl

      e

       

       

      "GC task thread#3 (ParallelGC)" prio=6 tid=0x0000000002096000 nid=0x1cc0 runnabl

      e

       

       

      "VM Periodic Task Thread" prio=10 tid=0x000000000816f800 nid=0x748 waiting on co

      ndition

       

       

      JNI global references: 3197

       

       

      Heap

      PSYoungGen      total 232960K, used 178371K [0x00000000ef500000, 0x000000010000

      0000, 0x0000000100000000)

        eden space 193536K, 90% used [0x00000000ef500000,0x00000000f9f99948,0x00000000

      fb200000)

        from space 39424K, 9% used [0x00000000fd780000,0x00000000fdb17528,0x00000000ff

      e00000)

        to   space 38400K, 0% used [0x00000000fb200000,0x00000000fb200000,0x00000000fd

      780000)

      ParOldGen       total 175104K, used 92030K [0x00000000ce000000, 0x00000000d8b00

      000, 0x00000000ef500000)

        object space 175104K, 52% used [0x00000000ce000000,0x00000000d39dfbe8,0x000000

      00d8b00000)

      PSPermGen       total 80384K, used 80162K [0x00000000be000000, 0x00000000c2e800

      00, 0x00000000ce000000)

        object space 80384K, 99% used [0x00000000be000000,0x00000000c2e489f8,0x0000000

      0c2e80000)

       

        • 1. Re: SQL Dev 4.0.2.15 freezing
          user13705395

          Hmm....after a little further experimentation, it may not be hanging, just really, really slow.  In at least one case, the tab finished loading if I just waited around 10 minutes.  That's not really practical though, so I'd still like to work on this issue.

           

          Thanks!

          • 2. Re: SQL Dev 4.0.2.15 freezing
            Gary Graham-Oracle

            In order to see what is taking so long, do the following:

            1. In your install's sqldeveloper.conf file, change IncludeConfFile  sqldeveloper-nondebug.conf to use sqldeveloper-debug.conf instead.

            2. Restart SQL Developer and open View > Log.

            3. Wait until the startup processing stops adding entries to the Logging page.  Remember the highest sequence number.

            4. Open your connection.

            5. In the Logging page, note the Elapsed times for each entry greater than the sequence from step 3, and the Source / Message that uses that time.

            If the culprit is something that is not logged, try to note the consecutive sequence numbers that suffer long pauses in between.

            • 3. Re: SQL Dev 4.0.2.15 freezing
              user13705395

              Thanks Gary.  I did as you suggested but results were a little mixed. In short, I didn't have the issue after I changed to use sqldeveloper-debug.conf

               

              Here's the longest line from the portion of logging that occurred when I would normally have trouble:

              FINER21898480oracle.dbtools.raptor.controls.display.DisplayPanelDisplayPanel.buildUI()

               

              But opening the table now takes maybe 5-10 seconds instead of 5-10 minutes.  I know it doesn't really "solve" the problem, but any issue with just leaving it in debugging mode?  :-)

              • 4. Re: SQL Dev 4.0.2.15 freezing
                Gary Graham-Oracle

                any issue with just leaving it in debugging mode?

                Should just be minor overhead.  Whatever makes you happy.,, but you might try switching debug off again to see if the performance worsens -- that would really be surprising!  Anyway, now you know how to achieve some level of visibility into such performance issues if you choose.