We need more info.
What OS are you on?
What JDK are you using?
What version of Oracle are you connected to?
I've got the same problem. As soon as I connect to the DB, supose I write "SELECT * FROM DUAL;" and press F5. No problem. Now I write "SELECT 1/0 FROM DUAL" and execute. The problem whit screen appears.
My OS: Windows 7 Professional 32 bits Service Pack 1
Oracle version: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
I just get a
Error starting at line : 1 in command -
SELECT 1/0 FROM DUAL
Error report -
SQL Error: ORA-01476: divisor is equal to zero
01476. 00000 - "divisor is equal to zero"
The question is I can't see the error text because the screen is not repainting. And in the log window I see the error about RaptorTaskManager.
- If a freeze is not some sort of deadlock, then it could be a memory limitation. The fact you are using a 32-bit OS makes me suspicious. Have you modified the Java -Xms or -Xmx memory limit in your product.conf file? (In C:\Users\<yourID>\AppData\Roaming\sqldeveloper\4.1.0). If the setting (even the default) is higher than available RAM, then that could be the problem. Or if it is lower than what SQL Developer needs (depending on what you have been doing and for how long), then you may be experiencing thrashing due to JVM garbage collection.
- Are you really using 4.1.0? In 4.0.x there was a problem with using the Ctrl+C, Ctrl-V copy/paste shortcut keys: SQL Developer Unresponsive
In product.conf every line is commented but one saying "SetJavaHome C:\Program Files\Java\jdk1.8.0_25". And the version is 18.104.22.168. In fact I've being using SQL Developer a long time, and I had this problem with all the versions after 3.2.20.09 (in the same computer, I suppose I need a newer one ).
I suppose I need a newer one
Very probably. In early 2014 nearly 50% of Win 7 installs were 64-bit, and clock in tech-time spins pretty fast. If you are stuck on 32-bit, however, the next suggestion is to update your video driver or at least search the web for issues with your video card / driver combination. I even read of one user blaming a Lenovo mouse driver for the infamous copy/paste hang. Anyway, good luck!
this seems to be the same issue described on this thread I opened several months ago:
I opened a SR to fix/investigate the issue. this is the bug: 20548707. It's on this state: "44 - Not Feasible to fix, to Filer" Not sure what it means...
I wrote this only to state that I reproduced the issue on different computers (some of them quite new & fast), so I maybe the speed of the computer is not relevant at all. I hope this issue could be fixed son as is quite irritant (also, this issue could be dangerous as you can't know what gone wrong or right in the script output).
Thanks in advance
I believe that bug was put into a "Not Feasible to fix" status because QA could not reproduce the behavior using your test case. Neither could I.
I assume the problem either has something to do with...
1. your environment (software / hardware).
2. corruption in your user profile settings: C:\Users\<yourUserid>\AppData\Roaming\SQL Developer\system<sqldevbuild>
So if you are still using 22.214.171.124.84, you could try upgrading to the latest 126.96.36.199.59 and just skip the settings migration step to see if the problem still exists.
Ok, I'll try it (btw the issue persist on 188.8.131.52.59).
Thinking about it, this are the only two "special" things installed:
- plugins: show me the password, keepalive
- a large set of connections imported via xml.
What is strange, is that on sqldeveloper version on linux the issue does not occur (with the same version, plugins and connections).
I'll post feedback about a fresh sqldeveloper install.
Thanks in advance.
Sorry for keep this thread alive but... same issue on 184.108.40.206 (with settings skipped on the 1st start)
Am I the only one? I can't understand what could cause this. Anyway I think the cause is clear:
SEVERE 352 30 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null en java.util.StringTokenizer.nextToken(StringTokenizer.java:349)
Any chance to send this error to a java developer to see if this could be a bug on the sqldeveloper code? Any hint? I opened a SR a while ago a nothing was detected.
Take note that I tested it in various hw environments (all on Windows 7 64bit).
Thanks in advance!
I don't know why, but the problem I was having long time ago with this issue has dissapeared with the next line in sqldeveloper.conf:
It forces SQL Developer to use English GUI, instead of the one I was using (Spanish)
Setting the english option did the trick!!! thanks a lot user6545024!!!
maybe could be useful send this workaround to developers team ....
Gary, what do you think about sending this to developers? I suppose they can reproduce this behaviour using a non English GUI