This discussion is archived
14 Replies Latest reply: Mar 4, 2011 2:08 AM by -K- RSS

30EA3/30EA2: Hangs navigating through the grid

-K- Guru
Currently Being Moderated
Hi,

This one is tricky. On three occasions already, I was browsing contents of a report; using the scroll bar, mouse wheel, CTRL-END, and clicking inside cells.
Then sqldev hangs badly: the UI consistently getting focus (but without repainting), everytime I try to switch to another application.

Here's the stack:
Full thread dump Java HotSpot(TM) Client VM (14.2-b01 mixed mode):

"RaptorTask: Displaying Results" prio=6 tid=0x06c75400 nid=0x1370 waiting on condition [0x0ef7f000]
   java.lang.Thread.State: TIMED_WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x13c8af10> (a java.util.concurrent.SynchronousQueue$TransferStack)
        at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:198)
        at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:424)
        at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:323)
        at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:874)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:945)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)

"DebuggingProcessTimer" prio=6 tid=0x06e0c400 nid=0xe14 in Object.wait() [0x05d3f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x16dad700> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"Background Parser" prio=6 tid=0x06c62c00 nid=0x978 waiting on condition [0x0ee7f000]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:127)
        at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
        at java.lang.Thread.run(Thread.java:619)

"status-0" prio=2 tid=0x06ebf400 nid=0xe0 waiting on condition [0x0f77f000]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x1389dca0> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
        at java.util.concurrent.DelayQueue.take(DelayQueue.java:160)
        at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:329)
        at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:291)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)

"WeakDataReference polling" prio=2 tid=0x06de5000 nid=0x17b4 in Object.wait() [0x0f47f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
        - locked <0x16cc1988> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
        at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)
        at java.lang.Thread.run(Thread.java:619)

"DataPopulation Thread" daemon prio=6 tid=0x06c71c00 nid=0xf70 waiting on condition [0x0772f000]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x13c321a8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
        at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:358)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)

"RaptorTask: StatementRunner Task" prio=6 tid=0x06be1c00 nid=0xf98 waiting on condition [0x053ff000]
   java.lang.Thread.State: TIMED_WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x13c8af10> (a java.util.concurrent.SynchronousQueue$TransferStack)
        at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:198)
        at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:424)
        at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:323)
        at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:874)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:945)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)

"Background Parser" prio=6 tid=0x06bc8400 nid=0x169c waiting on condition [0x05f3f000]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:127)
        at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
        at java.lang.Thread.run(Thread.java:619)

"Image Animator 3" daemon prio=4 tid=0x06c23400 nid=0x544 waiting on condition [0x0593f000]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:653)
        at sun.awt.image.GifImageDecoder.readImage(GifImageDecoder.java:441)
        at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:195)
        at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:246)
        at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:172)
        at sun.awt.image.ImageFetcher.run(ImageFetcher.java:136)

"Checkpointer" daemon prio=6 tid=0x04b9a800 nid=0x13f0 in Object.wait() [0x0ec7f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at com.sleepycat.je.utilint.DaemonThread.run(DaemonThread.java:152)
        - locked <0x14a028b8> (a java.lang.Object)
        at java.lang.Thread.run(Thread.java:619)

"INCompressor" daemon prio=6 tid=0x0654d400 nid=0x10ec in Object.wait() [0x0792f000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at com.sleepycat.je.utilint.DaemonThread.run(DaemonThread.java:154)
        - locked <0x14a029a8> (a java.lang.Object)
        at java.lang.Thread.run(Thread.java:619)

"Native Directory Watcher" prio=2 tid=0x069ce000 nid=0x750 runnable [0x064ef000]
   java.lang.Thread.State: RUNNABLE
        at oracle.ide.natives.NativeHandler.enterWatcherThread(Native Method)
        at oracle.ide.natives.NativeHandler$2.run(NativeHandler.java:252)
        at java.lang.Thread.run(Thread.java:619)

"Background Parser" prio=6 tid=0x04f89800 nid=0x13a4 waiting on condition [0x0ed7f000]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:127)
        at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
        at java.lang.Thread.run(Thread.java:619)

"TextBufferScavenger" prio=6 tid=0x06b13c00 nid=0x153c in Object.wait() [0x0eb7f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x144e15a8> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
        - locked <0x144e15a8> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
        at oracle.ide.model.TextNode$FacadeBufferReference$PollingThread.run(TextNode.java:1949)

"IconOverlayTracker Timer" prio=6 tid=0x068c0400 nid=0x16a4 in Object.wait() [0x0782f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x14204850> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"Timer queue for AWT thread" daemon prio=6 tid=0x06858c00 nid=0x12bc in Object.wait() [0x0623f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x1414ff80> (a java.lang.Object)
        at java.lang.Object.wait(Object.java:485)
        at ice.util.awt.TimedAWTExecutor.nextElem(TimedAWTExecutor.java:108)
        - locked <0x1414ff80> (a java.lang.Object)
        at ice.util.awt.TimedAWTExecutor.runScheduler(TimedAWTExecutor.java:130)
        at ice.util.awt.TimedAWTExecutor$1.run(TimedAWTExecutor.java:19)

"WaitCursor-Timer" prio=6 tid=0x06781400 nid=0x15e8 in Object.wait() [0x0603f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x1412e408> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"BaseTreeExplorer.NodeOpeningExecutor" prio=6 tid=0x06668c00 nid=0x780 waiting on condition [0x05e3f000]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x13c74538> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
        at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:358)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)

"Scheduler" daemon prio=6 tid=0x066aa400 nid=0x518 in Object.wait() [0x05c3f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)
        - locked <0x13c746e8> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:429)

"Thread-6" daemon prio=6 tid=0x06693400 nid=0x177c in Object.wait() [0x05b3f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x13ba4658> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
        - locked <0x13ba4658> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
        at org.tmatesoft.svn.core.javahl.SVNClientImplTracker.run(SVNClientImplTracker.java:65)
        at java.lang.Thread.run(Thread.java:619)

"TimerQueue" daemon prio=6 tid=0x066c2000 nid=0x1444 in Object.wait() [0x05a3f000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at javax.swing.TimerQueue.run(TimerQueue.java:236)
        - locked <0x13be4bd8> (a javax.swing.TimerQueue)
        at java.lang.Thread.run(Thread.java:619)

"ChangeSetService" prio=2 tid=0x04f1e000 nid=0x11d8 in Object.wait() [0x0583f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x13aa3388> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
        at java.lang.Object.wait(Object.java:485)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:178)
        - locked <0x13aa3388> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:199)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$200(ChangeSetService.java:56)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService$2.run(ChangeSetService.java:138)
        at java.lang.Thread.run(Thread.java:619)

"TimedCache-Timer" daemon prio=6 tid=0x03bb7800 nid=0xcb0 in Object.wait() [0x0476f000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.util.TimerThread.mainLoop(Timer.java:509)
        - locked <0x1320dde8> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"JarIndex Timer" daemon prio=6 tid=0x03b89400 nid=0xab8 in Object.wait() [0x0426f000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.util.TimerThread.mainLoop(Timer.java:509)
        - locked <0x131980c8> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"AWT-EventQueue-0" prio=6 tid=0x03b59800 nid=0x2bc runnable [0x04141000]
   java.lang.Thread.State: RUNNABLE
        at oracle.dbtools.raptor.controls.grid.AbstractRaptorGridModel.isTaskRunning(AbstractRaptorGridModel.java:256)
        at oracle.dbtools.raptor.controls.grid.AbstractRaptorGridModel.getValueAt(AbstractRaptorGridModel.java:56)
        at javax.swing.JTable.getValueAt(JTable.java:2695)
        at oracle.dbtools.raptor.controls.display.DisplayResultTable.getBinds(DisplayResultTable.java:173)
        at oracle.dbtools.raptor.controls.display.DisplayPanel$SelectChanged.parentSelectionChanged(DisplayPanel.java:160)
        at oracle.dbtools.raptor.controls.display.DisplayAdapter.fireSelectionChanged(DisplayAdapter.java:65)
        at oracle.dbtools.raptor.controls.display.DisplayResultTable$1.valueChanged(DisplayResultTable.java:54)
        at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:167)
        at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:147)
        at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:194)
        at javax.swing.DefaultListSelectionModel.insertIndexInterval(DefaultListSelectionModel.java:615)
        at javax.swing.JTable.tableRowsInserted(JTable.java:4468)
        at javax.swing.JTable.tableChanged(JTable.java:4404)
        at oracle.dbtools.raptor.controls.grid.RaptorGridTable.tableChanged(RaptorGridTable.java:839)
        at javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:280)
        at oracle.dbtools.raptor.controls.grid.AbstractRaptorGridModel$FetchTaskAdapter.notifyGridTable2(AbstractRaptorGridModel.java:447)
        at oracle.dbtools.raptor.controls.grid.AbstractRaptorGridModel$FetchTaskAdapter$1.run(AbstractRaptorGridModel.java:393)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)


        [goes on for hundreds of lines]


        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:269)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at java.awt.Component.show(Component.java:1563)
        at java.awt.Component.setVisible(Component.java:1515)
        at java.awt.Window.setVisible(Window.java:841)
        at java.awt.Dialog.setVisible(Dialog.java:985)
        at oracle.dbtools.raptor.backgroundTask.TaskDialog.showDelayedDialog(TaskDialog.java:79)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.showModalDialog(RaptorTaskManager.java:287)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager.access$600(RaptorTaskManager.java:38)

"AWT-Windows" daemon prio=6 tid=0x03b29000 nid=0x1438 runnable [0x03f5f000]
   java.lang.Thread.State: RUNNABLE
        at sun.awt.windows.WToolkit.eventLoop(Native Method)
        at sun.awt.windows.WToolkit.run(WToolkit.java:291)
        at java.lang.Thread.run(Thread.java:619)

"AWT-Shutdown" prio=6 tid=0x03b28400 nid=0x1364 in Object.wait() [0x03e5f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259)
        - locked <0x131982d0> (a java.lang.Object)
        at java.lang.Thread.run(Thread.java:619)

"Java2D Disposer" daemon prio=10 tid=0x03adb800 nid=0x1764 in Object.wait() [0x03d5f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
        - locked <0x13198360> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
        at sun.java2d.Disposer.run(Disposer.java:125)
        at java.lang.Thread.run(Thread.java:619)

"Low Memory Detector" daemon prio=6 tid=0x03151400 nid=0xea4 runnable [0x00000000]
   java.lang.Thread.State: RUNNABLE

"CompilerThread0" daemon prio=10 tid=0x0314b800 nid=0x1230 waiting on condition [0x00000000]
   java.lang.Thread.State: RUNNABLE

"Attach Listener" daemon prio=10 tid=0x0314a000 nid=0x11ec runnable [0x00000000]
   java.lang.Thread.State: RUNNABLE

"Signal Dispatcher" daemon prio=10 tid=0x03148c00 nid=0x1268 waiting on condition [0x00000000]
   java.lang.Thread.State: RUNNABLE

"Finalizer" daemon prio=8 tid=0x03139c00 nid=0xf3c in Object.wait() [0x034bf000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118)
        - locked <0x13140298> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134)
        at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

"Reference Handler" daemon prio=10 tid=0x03135000 nid=0x12a4 in Object.wait() [0x033bf000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
        - locked <0x13140320> (a java.lang.ref.Reference$Lock)

"main" prio=6 tid=0x00977800 nid=0xb34 waiting on condition [0x00000000]
   java.lang.Thread.State: RUNNABLE

"VM Thread" prio=10 tid=0x03131000 nid=0x15ec runnable

"VM Periodic Task Thread" prio=10 tid=0x0315bc00 nid=0x13bc waiting on condition

JNI global references: 9291

Heap
 def new generation   total 10560K, used 3064K [0x10010000, 0x10b80000, 0x13140000)
  eden space 9408K,  24% used [0x10010000, 0x1024baf0, 0x10940000)
  from space 1152K,  67% used [0x10a60000, 0x10b228b8, 0x10b80000)
  to   space 1152K,   0% used [0x10940000, 0x10940000, 0x10a60000)
 tenured generation   total 139468K, used 96044K [0x13140000, 0x1b973000, 0x38010000)
   the space 139468K,  68% used [0x13140000, 0x18f0b290, 0x18f0b400, 0x1b973000)
 compacting perm gen  total 66816K, used 66690K [0x38010000, 0x3c150000, 0x40010000)
   the space 66816K,  99% used [0x38010000, 0x3c130bd8, 0x3c130c00, 0x3c150000)
No shared spaces configured.
Hope that helps,
K.
  • 1. Re: 30EA2: Hangs navigating through the grid
    499310 Journeyer
    Currently Being Moderated
    Don't see a dead lock. This one should return. Takes a while or goes for more than few mins ?

    I could not replicate it but don't disbelieve that it could go wrong.

    Another thread dump & step-wise steps to get there would help.

    -Raghu
  • 2. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    I can't afford to not use my PC for too long, but I waited at least 5-10 minutes though. Enough to jerk around in Windows and try to switch to the console to get the dump.
    What about the 100s of looping statements in that event thread? I reckon that's proof of an infinite loop.
    I can replicate just doing the CTRL-END in the report, then clicking inside a cell (at the bottom of the set).

    K.
  • 3. Re: 30EA2: Hangs navigating through the grid
    499310 Journeyer
    Currently Being Moderated
    I get the task progress dialog named "Displaying Results" as soon I do ctrl-end. Yes, there is split second before it comes up. Before this comes up there is also a "invisible" modal dialog that exists just to make sure you get "Displaying Results" only after a few millisecs later than the task starting (coz many tasks finish before those millisecs & you'd hate flashing dialogs).
    Ok, there is a split second before this "invisible" dialog comes up. You are able to click inside the cell in that duration ?

    Are you a bot ? ;-) Get a human along to vouch !

    -Raghu
  • 4. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    As I click in a cell near the bottom, I'm pretty sure I'm past that dialog.
    But I was using a master-detail (kind of session browser), which detail (current statement) makes the dialog come up again.
    Anyhow, there are clearly situations from which sqldev can't recover. Bot or not, they can and will be hit by other users. Please debug the "AWT-EventQueue-0".

    K.
  • 5. Re: 30EA2: Hangs navigating through the grid
    499310 Journeyer
    Currently Being Moderated
    But I was using a master-detail (kind of session browser), which detail (current statement) makes the dialog come up again.
    This should help to replicate.

    Qs
    1. You did ctrl-end in Master or Detail. I guess Master. Plz confirm.
    2. You clicked in the cell in Master or Detail ? I guess Master. Plz confirm.
    3. Did you hit a cell in Master & then did ctrl-end ? I mean, did you change the selection before doing ctrl-end ?

    -Raghu
  • 6. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    1. Yes, master (couple of hundreds of entries). Detail has only 1.
    2. Yes, master
    3. Don't really get your question. I click any cell in the master just to have the focus in the right pane, then CTRL-END, then a cell in the master record (of which I want to view the current statement in the detail).
    But before clicking a cell, I normally I have to scroll up first to locate the session I want (using mousewheel or scrollbar). Not really sure I can still replicate that way.

    Hope that helps,
    K.
  • 7. Re: 30EA2: Hangs navigating through the grid
    499310 Journeyer
    Currently Being Moderated
    Logged Bug 10385605 - ea2: hang browsing master-child grid

    I am not able to replicate it. Would try more with programatically adding delay in child grid refresh.

    Btw, have you set auto-refresh-rate in child grid ?

    -Raghu
  • 8. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    No auto-refresh anywhere.
    BTW, I just replicated without even clicking in a master cell; just CTRL-END in the master pane, then clicked in the upper part of the scroll bar (to scroll up a screen). Sqldev hung with 50% CPU use (2-core), and the dump was virtually the same; hundreds of repeating entries in the "AWT-EventQueue-0"...

    Regards,
    K.

    PS: Here's the sessions report I use most. To replicate exactly, leave the detail in the Current SQL tab, then CTRL-END etc. :
    <?xml version="1.0" encoding="UTF-8" ?><displays><display id="test_ID" type="" style="Table" enable="true">
         <name><![CDATA[Sessions Browser]]></name>
         <description><![CDATA[]]></description>
         <tooltip><![CDATA[]]></tooltip>
         <drillclass><![CDATA[]]></drillclass>
         <CustomValues>
              <TYPE>horizontal</TYPE>
         </CustomValues>
         <query>
              <sql><![CDATA[SELECT s.username, UPPER (s.program) program, s.SID, ROUND (BITAND (s.ownerid, 65535)) parent_session_sid, ROUND (BITAND (s.ownerid, 16711680) / 65536) parent_session_instid, rawtohex(s.saddr) SADDR, s.serial#, s.audsid, rawtohex(s.paddr) PAADR, s.user#, s.command, s.ownerid, s.taddr, s.lockwait, s.status, s.server, s.schema#, s.schemaname, s.osuser, s.process, s.machine, s.terminal, s.TYPE, rawtohex(s.sql_address) SQL_ADDRESS, s.sql_hash_value, rawtohex(s.prev_sql_addr) PREV_SQL_ADDR, s.prev_hash_value, s.module, s.module_hash, s.action, s.action_hash, s.client_info, s.fixed_table_sequence, s.row_wait_obj#, s.row_wait_file#, s.row_wait_block#, s.row_wait_row#, to_char(s.logon_time, 'DD/MM/YYYY HH24:MI:SS') LOGON_TIME, s.last_call_et, s.pdml_enabled, s.failover_type, s.failover_method, s.failed_over, s.resource_consumer_group, s.pdml_status, s.pddl_status, s.pq_status FROM v$session s WHERE ( (s.username IS NOT NULL) /*AND (NVL (s.osuser, 'x') <> 'SYSTEM')*/ AND (s.TYPE <> 'BACKGROUND')) ORDER BY "PROGRAM", ownerid
    ]]></sql>
         </query>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Session]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT audsid, client_info, command, last_call_et, lockwait, to_char(logon_time, 'DD/MM/YYYY HH24:MI:SS') LOGON_TIME, machine, module, osuser, rawtohex(paddr) PADDR, process, program, schemaname, serial#, server, SID, status, terminal, TYPE, action, username, failover_method, failed_over, failover_type, pdml_enabled, pddl_status, pdml_status, pq_status, resource_consumer_group FROM v$session s WHERE SID = :SID AND ( (s.username IS NOT NULL) AND (NVL (s.osuser, 'x') <> 'SYSTEM') AND (s.TYPE <> 'BACKGROUND'))
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Process]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT rawtohex(ADDR), PID, SPID, USERNAME, SERIAL#, TERMINAL, PROGRAM, TRACEID, BACKGROUND, LATCHWAIT, LATCHSPIN FROM v$process WHERE (addr = :PAADR)
    ]]></sql>
                   <binds>
                        <bind id="PAADR">
                             <prompt><![CDATA[PAADR]]></prompt>
                             <tooltip><![CDATA[PAADR]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[IO]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT * FROM v$sess_io WHERE SID = :SID
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Current Waits]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[select SID,SEQ#,EVENT,P1TEXT,P1,rawtohex(P1RAW) P1RAW,P2TEXT,P2,rawtohex(P2RAW) P2RAW,P3TEXT,P3,rawtohex(P3RAW) P3RAW,WAIT_TIME,SECONDS_IN_WAIT,STATE from v$session_wait where sid=:SID
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Total Waits]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT ROWNUM, event, total_waits, total_timeouts, time_waited, average_wait, max_wait FROM v$session_event WHERE SID = :SID
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Current Statement]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT sql_text FROM v$sqltext_with_newlines WHERE hash_value = TO_NUMBER (:SQL_HASH_VALUE) ORDER BY piece
    ]]></sql>
                   <binds>
                        <bind id="SQL_HASH_VALUE">
                             <prompt><![CDATA[SQL_HASH_VALUE]]></prompt>
                             <tooltip><![CDATA[SQL_HASH_VALUE]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Open Cursors]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[select rawtohex(SADDR) SADDR,SID,USER_NAME,rawtohex(ADDRESS) ADDRESS,HASH_VALUE,SQL_TEXT from v$open_cursor where sid = :SID
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Access]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT SID, owner, TYPE, OBJECT FROM v$access WHERE SID = :SID
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[ Locks]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT /*+ RULE */ lk.SID, se.username, se.osuser, se.machine, DECODE (lk.TYPE, 'TX', 'Transaction', 'TM', 'DML', 'UL', 'PL/SQL User Lock', lk.TYPE ) lock_type, DECODE (lk.lmode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR (lk.lmode) ) mode_held, DECODE (lk.request, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR (lk.request) ) mode_requested, TO_CHAR (lk.id1) lock_id1, TO_CHAR (lk.id2) lock_id2, ob.owner, ob.object_type, ob.object_name, lk.BLOCK, se.lockwait FROM v$lock lk, dba_objects ob, v$session se WHERE lk.TYPE IN ('TM', 'UL') AND lk.SID = se.SID AND lk.id1 = ob.object_id(+) AND (lk.SID = :SID)
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[RBS Usage]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT r.segment_name, r.tablespace_name, s.SID, s.serial#, s.username, s.machine, t.status, t.cr_get, /*consistent gets*/ t.phy_io, /*physical io*/ t.used_ublk, /*Undo blocks used*/ t.noundo, /*Is a noundo transaction*/ SUBSTR (s.program, 1, 78) "COMMAND", s.username "DB User", t.start_time, s.sql_address "Address", s.sql_hash_value "Sql Hash" FROM SYS.v_$session s, SYS.v_$transaction t, SYS.dba_rollback_segs r WHERE t.addr = s.taddr AND t.xidusn = r.segment_id and s.SID = :SID ORDER BY t.start_time
    ]]></sql>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Long Ops]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[select SID,SERIAL#,OPNAME,TARGET,TARGET_DESC,SOFAR,TOTALWORK,UNITS, to_char(START_TIME,'DD/MM/YYYY HH24:MI:SS') START_TIME, to_char(LAST_UPDATE_TIME,'DD/MM/YYYY HH24:MI:SS') LAST_UPDATE_TIME, TIME_REMAINING,ELAPSED_SECONDS,CONTEXT,MESSAGE,USERNAME, rawtohex(SQL_ADDRESS) SQL_ADDRESS,SQL_HASH_VALUE,QCSID from v$session_longops where sid=:SID
    ]]></sql>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Statistics]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[SELECT a.SID, DECODE (b.CLASS, 1, 'User', 2, 'Redo', 4, 'Enqueue', 8, 'Cache', 16, 'OS', 32, 'ParallelServer', 64, 'SQL', 128, 'Debug', 72, 'SQL & Cache', 40, 'ParallelServer & Cache' ) CLASS, b.NAME, a.VALUE FROM v$sesstat a, v$statname b WHERE (a.statistic# = b.statistic#) AND SID = :SID
    ]]></sql>
                   <binds>
                        <bind id="SID">
                             <prompt><![CDATA[SID]]></prompt>
                             <tooltip><![CDATA[SID]]></tooltip>
                             <value><![CDATA[NULL_VALUE]]></value>
                        </bind>
                   </binds>
              </query>
         </display>
         <display id="" type="Child" style="Table" enable="true">
              <name><![CDATA[Kill SQL]]></name>
              <description><![CDATA[]]></description>
              <tooltip><![CDATA[]]></tooltip>
              <drillclass><![CDATA[]]></drillclass>
              <CustomValues>
              </CustomValues>
              <query>
                   <sql><![CDATA[select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where sid = :SID
    ]]></sql>
              </query>
         </display>
    <item  reload="true"  reloadparent="false" removeFromParent="false"><title>Kill Session</title><prompt type="confirm" >     <label>Kill Session?</label>     </prompt><sql><![CDATA[BEGIN GEN_SESIONES_PKG.MATA(#SID#); END;]]></sql><help>Kill the selected session.</help></item></display>
    </displays>
  • 9. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    In EA3, I additionally see the "Displaying Results" dialog appearing and disappearing like every second or less, while the worksheet toolbar is activating and disactivating.

    K.
  • 10. Re: 30EA2: Hangs navigating through the grid
    499310 Journeyer
    Currently Being Moderated
    Bug 10385605 - ea2: hang browsing master-child grid is Open.

    -Raghu
  • 11. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    Don't know if anything was done in this area, but EA3 is actually a lot worse. I can do almost nothing with above report. Navigating with just the keyboard or just the mouse, it almost hangs instantly...

    K.
  • 12. Re: 30EA2: Hangs navigating through the grid
    Sentinel Pro
    Currently Being Moderated
    I'd like to chime in here and say that I've been experiencing this same issue with all 3 EAs (just hadn't figured out how best to report the issue or get the dump). It usually happens on a report that requires multiple fetches to return all records and occurs during the last fetch in the master pane.

    My impression is that once the last fetch is perfored some sort of connection or state information for the master report gets discarded?? and child reports or another process gets lost in an infinite loop repeatedly stealing the focus.

    So far the only way I've been able to deal with this issue is to get a process explorer window up to terminate the sqldeveloper instance.

    This issue is routinely reproducible, though on occasion a report that I expect to be subject to this issue isn't (though it might be at a later date). This tidbit leads me to wonder if the issue is related to the size of the final fetch, such that a final fetch that returns [fetch size] records is not affected, but anything less than [fetch size] experiences this issue. (My fetch size is the default of 50 records).

    Reports that I've never experienced this issue with are those that return all of the master records in the first fetch.
  • 13. Re: 30EA2: Hangs navigating through the grid
    499310 Journeyer
    Currently Being Moderated
    I have fixed the issue just the last week. Your diagonosis is spot on!
    -Raghu
  • 14. Re: 30EA2: Hangs navigating through the grid
    -K- Guru
    Currently Being Moderated
    AFAIK, this is fixed in EA4.

    Thanks,
    K.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points