I am getting hung sessions in SQL Developer. I suspect it's something in the communication layer and not the database.
The symptoms I am seeing are when I run a SQL statement it does not return for 10, 30 minutes, or longer, if at all. This is intermittent. I can be working along fine for an hour, and then suddenly it hangs, even though I ran the same script a few minutes before and got sub-second response time. When I try to cancel, it remains hung with that annoying cylon-eye inspired "working bar" thing going back and forth. I have to cancel the task, and of course I lose my work that I forgot to save...
while this is going on, I will switch over to sqlcl an run the SQL script there. Runs fine (most of the time), sometimes not.
One hypothesis: Sometimes it seems to be on an error in SQL statement, like it didn't get the error message back.
Running SQLDeveloper Version 19.2.0.206 on win10
I see in the event viewer an AppHangB1 event.
Fault bucket , type 0
Event Name: AppHangB1
Response: Not available
Cab Id: 0
Problem signature:
P1: sqldeveloper64W.exe
P2: 19.2.0.206
P3: 5c747444
P4: 683b
P5: 67246080
P6:
P7:
P8:
P9:
P10:
SQL Developer Log entries
SEVERE 408 0 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.dbtools.raptor.startpage.StartPageViewer.updateDocument(StartPageViewer.java:288)
SEVERE 418 17162 oracle.dbtools.raptor.insight.InsightCache InsightCache.fillIn() time = 8853 ret.size()= 339167
SEVERE 425 25868 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.dbtools.raptor.startpage.StartPageViewer.updateDocument(StartPageViewer.java:288)
SEVERE 438 47666 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.dbtools.raptor.startpage.StartPageViewer.updateDocument(StartPageViewer.java:288)
SEVERE 541 797121 oracle.dbtools.raptor.insight.InsightCache InsightCache.fillIn() time = 13852 ret.size()= 383004
SEVERE 578 17234 oracle.dbtools.raptor.insight.InsightableOracleDatabase ORA-01013: user requested cancel of current operation
SEVERE 579 3594 oracle.dbtools.raptor.insight.InsightableOracleDatabase ORA-01013: user requested cancel of current operation
Could it be something is blocking two-way communication between the DB and SQL Developer?